Move first 5000 records from 2 input file to 1 output file



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Move first 5000 records from 2 input file to 1 output file

Postby jkkarthik » Thu Sep 23, 2010 1:48 pm

Hi all,

I am new to ICETOOL. I have a requirement like below

I have more than one input file to the sort step. I should move the first 5000 records to the output file and remaining records should be written to the same input file again.

Example
File 1 - 6000 records
File 2 - 7000 records

After my first run
File 1 - 1000 records (First 5000 records moved to the output file)
File 2 - 7000 records - no change

After second run
File 1 - 0 Records
File 2- 3000 records

During the second run, 1000 records from first file and 4000 records from second file should be written to output file.

Please guide me to solve this problem.


Regards
Karthik Jayabalan
jkkarthik
 
Posts: 3
Joined: Wed Jul 07, 2010 10:50 am
Has thanked: 0 time
Been thanked: 0 time

Re: Move first 5000 records from 2 input file to 1 output file

 

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post