IBM Mainframe Forum

Hello,


i would like getting the 25 th first columns of a sortin data.

My sortout data is already existing and his LRECL is 117 (FB format).

The BIND doesn't work because my SORTOUT DATA has not a 25 LRECL...

Thanks for you help.

I do not really understand what you are saying/asking or trying to do. Columns are DB2 things - sort uses fields. What BIND does not work? You do not bind when sorting. Is this a sort or DB2 question?

This is the sysin of the program SORT



Sorry, it's not BIND but BUILD

It doesn't work because the sortout dataset has an LRECL too long...

what is wrong with just creating a new dataset? And omit the DCB values - DFSORT will handle those.

samb01,

The SORTOUT LRECL must MATCH the reformatted BUILD length. If you want output LRECL=117, you must pad the reformatted records to 117 bytes, e.g. to pad with blanks use:

i would like getting the 25 th first columns of a sortin data.

Then why are you using 50 instead of 25?

what is wrong with just creating a new dataset? And omit the DCB values - DFSORT will handle those.

That will work if he wants SORTOUT LRECL=50, but not if he wants SORTOUT LRECL=117.

Frank Yaeger wrote:samb01,

The SORTOUT LRECL must MATCH the reformatted BUILD length. If you want output LRECL=117, you must pad the reformatted records to 117 bytes, e.g. to pad with blanks use:

Select all

   OUTFIL FNAMES=SORTOUT,BUILD=(1,50,117:X)   

i would like getting the 25 th first columns of a sortin data.

Then why are you using 50 instead of 25?

Thanks a lot Frank Yaeger,

it is what i want. The number 25 is a mistake... I want the 50 th fisrt columns.