I have a requirement for copying a flat file into multiple files say 20 files with some changes.
For example
File structure/record are
Code:
ORDR AMT. DATE
1234 1111111111 01/01/2014
4567 2222222222 01/01/2015
....
9999 4455667777 01/01/2299
Then the result should be any (random ) change in date, order and amount, but there should be chnage
The result can be
Code:
ORDR AMT. DATE
1232 1111456121 31/12/1999
5588 2222222222 01/01/2000
....
9001 0000667767 01/01/1875
can it be done by any SORT/ICETOOL utility,
Btw I am thinking of following below approach for order number chnage , not complete JCL ,
But don't know whether it will be efficient and would work properly or not
Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
I think, perhaps, maybe, trying to be psychic on a non-psychic day, TS wants to copy all the input records to all the output files changing key fields so that they could not be traced back to the original file. Perhaps copying a production file to testing and obfuscating the data in the process. Except it would still be record 1 relates to record 1 in all the other files.