Need to load a column from a header field.

Analytics

Need to load a column from a header field.

Hi All,

I have a file with 1 header record starting with 0. Detail records starting with 1 and trailer record starting with 9.

We do a normal fload on the table loading the records. Now i need to introduce a new column which will get its value from the header field. char(1).

How do i go about it?

thanks,
priti
1 REPLY
Enthusiast

Re: Need to load a column from a header field.

If the header record is always the first record on the file, do a BTEQ import of the first record only.
Otherwise, move to Multiload.