Page 1 of 1

JCL Sorting

PostPosted: Tue Oct 27, 2015 10:05 am
by Niks
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

Re: JCL Sorting

PostPosted: Tue Oct 27, 2015 6:23 pm
by BillyBoyo
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.

Re: JCL Sorting

PostPosted: Tue Oct 27, 2015 7:51 pm
by NicC
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.

Re: JCL Sorting

PostPosted: Wed Oct 28, 2015 9:30 am
by Niks
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

Re: JCL Sorting

PostPosted: Wed Oct 28, 2015 6:38 pm
by NicC
Do you know about symbols in DFSort? If not - start reading.

Re: JCL Sorting

PostPosted: Wed Oct 28, 2015 6:43 pm
by steve-myers
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.

Re: JCL Sorting

PostPosted: Wed Oct 28, 2015 8:50 pm
by BillyBoyo
There are lots of examples around. Here's one, http://ibmmainframes.com/about58490.html

Re: JCL Sorting

PostPosted: Thu Oct 29, 2015 8:47 am
by Niks
Thank you very much Billy boyo.