JCL Sorting



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

JCL Sorting

Postby Niks » Tue Oct 27, 2015 10:05 am

Hi All,

Can anyone Help me on this.

I have Two input Files.
1st File contains input Record as : Sachin,Sourav,rahul and many more.
2nd file contains input record as: is an indian.

output file should contain: Sachin is an indian,sourav is an indian ,Rahul is an indian .

Through sort I have to do it,can anyone help me on this.

Thanks and Regards,
Niks
Niks
 
Posts: 3
Joined: Tue Oct 27, 2015 9:52 am
Has thanked: 0 time
Been thanked: 0 time

Re: JCL Sorting

Postby BillyBoyo » Tue Oct 27, 2015 6:23 pm

Two steps. Generate a symbol file with the text from the one-record file. Needs to be 80-byte records.

Use the symbol file to add the text in a COPY operation.

If you want intervening blanks compressed, look at SQZ.

The heavy-resource way, which is maybe what you are supposed to find, is to use JOINKEYS to create a one-to-many join.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: JCL Sorting

Postby NicC » Tue Oct 27, 2015 7:51 pm

Not a JCL topic - moved to DFSort. If your sort product is not DFSort let us know which sort product you use and in future post your sort queries in the correct sort forum.
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

Re: JCL Sorting

Postby Niks » Wed Oct 28, 2015 9:30 am

Thanks Billy boyo.
Could you please explain me with the Code format , I didn't understand this how to use this.
(Use the symbol file to add the text in a COPY operation.)

Thanks and Regards,
Niks
Niks
 
Posts: 3
Joined: Tue Oct 27, 2015 9:52 am
Has thanked: 0 time
Been thanked: 0 time

Re: JCL Sorting

Postby NicC » Wed Oct 28, 2015 6:38 pm

Do you know about symbols in DFSort? If not - start reading.
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

Re: JCL Sorting

Postby steve-myers » Wed Oct 28, 2015 6:43 pm

When people mention the use of "code" it refers to a markup language you can use in these forums. See this link for a simplified discussion of the markup language. In addition, some of the entry forms have buttons you can click to insert the markup. The "Quick reply" entry form does not have these buttons, but by clicking on the "Full Editor" button just below the entry form you can get to an entry form with the markup buttons. You can click the Preview button to review your post before you submit the post, which is a good idea if you are entering a complex markup.
steve-myers
Global moderator
 
Posts: 2105
Joined: Thu Jun 03, 2010 6:21 pm
Has thanked: 4 times
Been thanked: 243 times

Re: JCL Sorting

Postby BillyBoyo » Wed Oct 28, 2015 8:50 pm

There are lots of examples around. Here's one, http://ibmmainframes.com/about58490.html
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: JCL Sorting

Postby Niks » Thu Oct 29, 2015 8:47 am

Thank you very much Billy boyo.
Niks
 
Posts: 3
Joined: Tue Oct 27, 2015 9:52 am
Has thanked: 0 time
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post