MVSFORUMS.com

[new user]

Hi

i have a sequential file of 80 bytes (FB). i am adding a identifier field of length 1 (which takes value 1,2) at position 81 using DFSORT and finally loading the values to a DB2 table.

The hardcoded identifier field should populate a column of type SMALLINT in the table.As SMALLINT is equivalent to PIC S9(4) COMP, the hardcoded value needs to be the binary equivalent of the identifier.

In that case, the OUTREC card should look something like

OUTREC = (1:1,80,81: B'10')

but it is not giving me the desired result in the table.

Thanks
-new user

[kolusu]

Try this

S9(04) comp is 2 bytes in length. so if you want to move 1 in that field, the following sort card gives you the desired result.

[Frank Yaeger]

Here's another way to do it with DFSORT:

[new user]

Thanks a lot Frank and Kolusu.

it really helped

Regards
-new user