1) I have 2 Input Files,Need to read these two input files Based on the commom key i.e CIDN (field) & if Field (CIDN) of File2 is not present in File1 then need to write File-2 records in to another file(FILE3)
2) Both contain three types of records
Header ,Trailer & Detail [detail-records or main-records "which need to
process"] Records.
3) Header records start with 0 (zero),main records start with 2 (two) and
Tailer records start with 9 in First Column.see below in example
4) There is Common Key (Field) in Both Input Files is (Customer Number)
i.e CIDN ,the KEY (Field )length is 10 (numeric) Which start from 2-10.
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Quote:
1)I ran the Job and got the results,but some data getting truncated in out file from 1093 to 1098.
You mean positions 1093-1098 from some input records are not appearing in the output records or are blanks or what? The job I gave you would not do that. So you either changed the job in some way or gave me the wrong information about your input records. If you want me to help you figure out what's wrong, you'll need to give me more information so I can figure out what's different between my job and yours or between my input and yours.
Quote:
if i need to get Header & Traile also in OUT file with Main records what changes required in ICETOOL JOB.
Did you want the header and trailer from file2 in the output file, or did you want something else? You need to show me what you expect for output with the input you showed.