MVSFORUMS.com

[Ameen]

Hi,

I have the following field in the DB2 table.

Field1 - X(35)
Field2 - S9(11)V USAGE COMP-3
Field3 - X(11)
Field4 - S9(9) USAGE COMP [this field always contains 2 digit no.]
Field5 - S9(9) USAGE COMP.[this field always contains 2 digit no.]

I want to unload the above fields in to a Dataset in the following format.

Field1 - X(35).
Field2 - 9(9).
Field3 - X(11).
Field4 - 9(2).
Field5 - 9(2).

I know about the unload but the attributes of fields should be in the format mentioned.

Please help me to do the same

[kolusu]

Ameen,

Try this

[Ameen]

kolusu,

Is there any other way, because Field2 will contain the quantity if we starting with position 3 value will truncate and also can we give above select in the platinum unload control card.

[bauer]

Hi Ameen,

if the unload doesn't accept the select statement (i don't know the meaning of "platinum" unload card ??????) create an view containing the type casting an do the unload using the view. This works.

regards,
bauer

[kolusu]