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
abcde
abcfg
abchi

xyziy
xyzuf
xyzdk

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

Thanks,
Agam
agam3007
 
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

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
prino
 
Posts: 635
Joined: Wed Mar 11, 2009 12:22 am
Location: Vilnius, Lithuania
Has thanked: 3 times
Been thanked: 28 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
cheers
enrico
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
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 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.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post