Replace an existing column with values from another file

drajagopal · New User Joined: 20 Jun 2006 Posts: 9

Hi,

Please find below my requirement.
This is a translation process where I want to replace an existing column(3 digit) with the new one(four digit).

For example:
Input files:

INPUT1:
01239xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
03507xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
00208yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy

INPUT2:
0200204
1231234
3503500

In INPUT1, column 2 to 4 is the code that has to be replaced with the correponding values from INPUT2.
INPUT 2 has from COL 1 - 3 the code and 4-7 its equivalent value. example, for code 123, the equivalent value is 1234.

Col 4 in INPUT1 is the check digit added to these codes, ie, 350 is written in input file as 3507. Instead of the code with check digit(eg:1239), we want the output file to have the equivalent value of the code(1234) from INPUT2.

OUTPUT has to be
01234xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
03500xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
00204yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy

We tried this sucessfully with ICETOOL utility. But there is considerable degradetion in performance, as the INPUT1 file has around 20 million records and the job takes almost 30 min to complete.
The INPUT File is Sequential, FB format & LRECL = 135.

Can anyone suggest a solution for this code conversion or to fine tune the ICETOOL utility?

William Thompson · Posted: Tue Feb 06, 2007 5:40 pm

It might help if you would post your ICETOOL jcl and control data.

drajagopal · New User Joined: 20 Jun 2006 Posts: 9

Hi,

Please find the attachment.

Thank you.

Frank Yaeger · Posted: Tue Feb 06, 2007 9:43 pm

I can't read your download file. It appears to be one big line. But from what I can tell, it appears to be doing more operations than necessary.

Here's a DFSORT/ICETOOL job that will do what you asked for. See if you can adapt it to what you need and if it runs faster than the one you're using.

dick scherrer · Posted: Tue Feb 06, 2007 10:01 pm

Hello,

If the attached file is right-clicked/saved as to a local drive, it opens ok. When opened vie IE, several of these have jumbled.

Here is the content.