DSXchange

Hi,
I got 2 ouput files with different stuctures. I need to append in to one file . and sort it based on COL2 and COL1 Please let me know:

Example:
File 1:
P001,101, US
P001,102, MI

File2:
P002,101, XYZ,234354432,loc,12
P002, 102, XYZ,43543,loc,13

I think it should be possible by unix scripting. If how it is

It could be done in DataStage also.

Do you know what commands you might use in such a script, or are you relying upon DSXchange to fill a gap in your knowledge of operating system commands?

This problem can be solved with a single command pipeline - you don't even need a script!