copying a single file to multiple file using sort/icetool

sumitmalik29 · New User Joined: 10 Feb 2008 Posts: 19 Location: bhuneswar

Hi All

I have a requirement for copying a flat file into multiple files say 20 files with some changes.

For example
File structure/record are

dick scherrer · Posted: Wed Dec 11, 2013 7:33 pm

Hello,

What are the rules for getting from the input to the output?

You need to explain how the first input record became the first output record. The posted code would not do this . . .

Deep in mind that you know what you mean, but we do not until you clarify.

Pandora-Box · Posted: Wed Dec 11, 2013 8:08 pm

Looking at your code and it is definitely not a random change but definitive change

In other words

Do You want to simulate your input file to 20 different output file ?

sumitmalik29 · New User Joined: 10 Feb 2008 Posts: 19 Location: bhuneswar

Dear All,

Sorry for confusion,
Please ignore my posted JCL

I need the input record to be copied in other 20 output files , with change in amount, date and order

it can be any change in Order Number ( any different numeric order Number, other than - corresponding input file and other output file's Order Number)

it can be any change in amount ( any numeric Amount, other than - corresponding input file and other output file's amount)

it can be any change in date ( any valid date, other than - corresponding input file and other output file's date )

For example if my input file is like
1234 1111111111 01/01/2014

Then my output for 1st file can be
1239 1111111911 01/01/2009

Output for 2nd file can be
1339 1111111011 01/01/2000

And so on .....

Output for 20th file can be
1833 1568140955 21/11/1965

any change in output file is okay for me
regarding Order Number, Amount and date

Thanks for your time and cooperation

dick scherrer · Posted: Wed Dec 11, 2013 10:12 pm

Hello,

You still haven't explained just what an old value is to be changed to . . . What rule is to be folllowed to create a "changed" output record?

For each record in the input file, Why can there be multiple output file/records written?

Maybe if you explain why there can be multiple output files, it will help.

As of now, we suspect you want do to Something, but i have no idea what this is . . .

Nic Clouston · Posted: Thu Dec 12, 2013 12:21 am

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.