How to map REDEFINES clause to a DB2 table?

guruji · New User Joined: 13 Apr 2007 Posts: 59 Location: Chennai

HI,

I am working to convert an existing VSAM to a DB2 table. The fields in VSAM copybook have to be mapped to corresponding field in DB2 table. But I am not able to map the field which is having REDEFINES clause in its definition to its corresponding field in DB2 table. Can you suggest a way to do the same?

Thanks,
Reni

muthuvel · Posted: Wed Jun 13, 2007 5:33 pm

REDEFINES is not possible with DB2 .
So you can better use the lowest group field(in the REDEFINE field) as a column so that it will be easy to map .

guruji · New User Joined: 13 Apr 2007 Posts: 59 Location: Chennai

Hi muthuvel,

I dint get you completely.What did you mean by lowest gp field? Can you please explain with an example?

William Thompson · Posted: Wed Jun 13, 2007 5:59 pm

Elementary item, not group item......

guruji · New User Joined: 13 Apr 2007 Posts: 59 Location: Chennai

Thank you