IBM Mainframe Forum

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

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.

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.

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

Do you know about symbols in DFSort? If not - start reading.

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.

There are lots of examples around. Here's one, http://ibmmainframes.com/about58490.html

Thank you very much Billy boyo.