Page 1 of 1

Divide a row into different rows

PostPosted: Tue Mar 01, 2016 5:33 pm
by agam3007
Hi All,
I have a row of LRECL 12500,i need to divide this row into different rows such that keys of the input rows comes in each row.

For example:-
Input records-
input record 1 : abcdefghi
input record 2 : xyziyufdk

Keys for record 1 :abc
Keys for record 1 :xyz

Expected Output
abcde
abcfg
abchi

xyziy
xyzuf
xyzdk

Please guide me the approach to do the above through JCL.

Thanks,
Agam

Re: Divide a row into different rows

PostPosted: Tue Mar 01, 2016 6:27 pm
by prino
And you're too much of a plank to see that this is not a topic for the suggestions and feedback forum?

Re: Divide a row into different rows

PostPosted: Tue Mar 01, 2016 6:46 pm
by enrico-sorichetti
the topic will be moved to the proper section as soon as the TS tells the sort product used,

messages starting with WER ==> sync sort
messages starting with ICE ==> ibm DFSORT

Re: Divide a row into different rows

PostPosted: Tue Mar 01, 2016 9:27 pm
by NicC
As mentioned above - not something for the Sggestions & Feedback part of the forum.

It cannot be done by JCL although JCL will be used (probably) to get the machine to execute the relevant program,

Also, please use the code tags to present data and code. Easily done when you are starting a new topic or use the POSTREPLY button to add a response.