I have a sort step, sort in containing two ps files ( take example AAA.TEST.TEST1,BBB.TEST.TEST2) and sortout ps file is AAA.TEST.TEST1
both input files conatinng large amount of data(millions of records).
Is any data destruction problem will occur ?
(i mean same file using as input and output )
You SHOULD NOT use the same data set for input and output for a COPY or MERGE application.
You can use the same data set for input and output for a SORT application, but it's generally a bad idea since you can lose the data set if an error occurs (e.g I/O error). Of course, if you don't care if the data set is destroyed (e.g. you have a backup) then you can do it. We call it a "suicide sort".