How do I retain value of a variable throughout the file...?
Posted: Mon Aug 02, 2004 5:13 pm
Hi All:
I have a variable length positional input file, upon which I use the CFF(Complex Flat File Stage) and separate the like records in different files.
So now I have a Header file which has only one record.
8 sequencial files with different record types in it.
And one Trailer/footer file with only one record.
This job picks up all the detail records and add the header fields to them. There is only one header record and the field values should get repeated in all the detail records.
I tried storing the header values in stage variables, but only the 1st detail record picks up the value, the variable does not retain the value for the following records.
Is there any way to retain the value of the variables....?
I cannot use the hash files to this job though it works perfectly fine, due to performance issues.
Thank You.
I have a variable length positional input file, upon which I use the CFF(Complex Flat File Stage) and separate the like records in different files.
So now I have a Header file which has only one record.
8 sequencial files with different record types in it.
And one Trailer/footer file with only one record.
This job picks up all the detail records and add the header fields to them. There is only one header record and the field values should get repeated in all the detail records.
I tried storing the header values in stage variables, but only the 1st detail record picks up the value, the variable does not retain the value for the following records.
Is there any way to retain the value of the variables....?
I cannot use the hash files to this job though it works perfectly fine, due to performance issues.
Thank You.