need to add new fields to variable dataset using icetool

kalukakkad · New User Joined: 10 Mar 2005 Posts: 81

I need to extract 2 fields from file1 and add these two to file2 if the key matches,how can i do this using icetool

File1-variable length-28
field-11
field-12
field-13
field-14

File2-variable length-110
field-21
field-22
field-23...till
field-29

now i need to add field-13 and field-14 from File1 to File2 so that the output file length = length of File2 + length(Field-13+field-14)

how can i use ICETOOL to accomplish this.

Frank Yaeger · Posted: Tue Aug 15, 2006 11:40 pm

You need to give more details.

What is the starting position, length and format of each field in file1, file2 and the output file? Remember that the RDW is in positions 1-4 and the first data byte starts in position 5.

What is the starting position, length and format of the key you want to match on in file1 and in file2?

Where exactly do you want to insert the fields in the output record?

Are all of the VB records in file1 the same length or do the lengths vary?
Are all of the VB records in file2 the same length or do the lengths vary?

It would help if you showed an example of the records in each input file and the expected output records.

kalukakkad · New User Joined: 10 Mar 2005 Posts: 81

kalukakkad · New User Joined: 10 Mar 2005 Posts: 81

I tried with this:

Frank Yaeger · Posted: Wed Aug 16, 2006 1:29 am

It appears that file1 has duplicate keys within it - right (AAA in both records)?

It appears that file2 does NOT have duplicate keys within it - right? If file2 can have duplicate keys within it, then show an example of input and output for that case.

Based on your COBOL layouts, the DFSORT position and lengths are as follows:

kalukakkad · New User Joined: 10 Mar 2005 Posts: 81

File-1 has duplicate keys

File-2 does not have duplicate keys

Yes, the output should have 1-106 from File-1 and 9-24 from File-2

Frank Yaeger · Posted: Wed Aug 16, 2006 3:52 am

Here's a DFSORT/ICETOOL job that will do what you asked for:

kalukakkad · New User Joined: 10 Mar 2005 Posts: 81

i am getting syntax error in OUTREC

Error description in DFSMSG
CTL1CNTL :
OUTREC BUILD=(1,4,C'BB',47:5,3,109:9,16)
*
OUTREC STATEMENT : SYNTAX ERROR

Error description in JESMSGLG
STEP01 , -OUTREC STATEMENT : SYNTAX ERROR
STEP01 - ABEND=S000 U0016 REASON=00000000

superk · Posted: Wed Aug 16, 2006 8:00 pm

kalukakkad, please post the ENTIRE error messages with the error codes intact.

kalukakkad · New User Joined: 10 Mar 2005 Posts: 81

PARMEXIT : SIZE=MAX-64K
CTL1CNTL :
OUTREC BUILD=(1,4,C'BB',47:5,3,109:9,16)
*
WER428I CALLER-PROVIDED IDENTIFIER IS "0001"
WER161B ALTERNATE PARM USED
WER268A OUTREC STATEMENT : SYNTAX ERROR
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000

Frank Yaeger · Posted: Wed Aug 16, 2006 8:43 pm

kalukakkad,

The WER messages indicate you're using Syncsort, not DFSORT. The job works fine with DFSORT.

I'm a DFSORT developer. DFSORT and Syncsort are competitive products. I'm happy to answer questions on DFSORT and DFSORT's ICETOOL, but I don't answer questions on Syncsort.

kalukakkad · New User Joined: 10 Mar 2005 Posts: 81

Thanks Frank for all the help u provided....