Divide a row into different rows

IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Divide a row into different rows

Postby agam3007 » Tue Mar 01, 2016 5:33 pm

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


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

Posts: 2
Joined: Tue Mar 01, 2016 4:18 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Divide a row into different rows


Re: Divide a row into different rows

Postby prino » Tue Mar 01, 2016 6:27 pm

And you're too much of a plank to see that this is not a topic for the suggestions and feedback forum?
Robert AH Prins
robert.ah.prins @ the.17+Gb.Google thingy
User avatar
Posts: 529
Joined: Wed Mar 11, 2009 12:22 am
Location: Oostende, Belgium
Has thanked: 3 times
Been thanked: 20 times

Re: Divide a row into different rows

Postby enrico-sorichetti » Tue Mar 01, 2016 6:46 pm

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
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
Global moderator
Posts: 2620
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 127 times

Re: Divide a row into different rows

Postby NicC » Tue Mar 01, 2016 9:27 pm

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.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Global moderator
Posts: 2681
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 102 times



  • Related topics
    Last post