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

 

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: 494
Joined: Wed Mar 11, 2009 12:22 am
Location: Oostende, Belgium
Has thanked: 3 times
Been thanked: 19 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: 2554
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 121 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: 2602
Joined: Sun Jul 04, 2010 12:13 am
Location: Not where I would like to be
Has thanked: 4 times
Been thanked: 92 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post