First line is column names in Input Tab

sumitgulati · Post by **sumitgulati** » Tue Dec 14, 2004 4:25 pm

Hi,

I have a job that reads an Oracle table and inserts it into a sequential file. I see an option in Sequential file stage in Input\Format tab - 'First line is column names'. I read the help on this and it says:

"Select this check box if the first row of data in the file contains column names. This option is cleared by default, i.e., the first row in the file contains data."

I did not quite understand it.

1) Does it mean that the first record from the input data will be ignored and the data will be processed into the sequential file from the second record.
OR
2) Does it mean that the sequential file stage will insert the column names defined in the Input\Columns tab into the file as a first line.

Kindly clarify.

Thanks and Regards,
-Sumit

adamski · Post by **adamski** » Tue Dec 14, 2004 4:42 pm

The second assumption is correct.

sumitgulati · Post by **sumitgulati** » Tue Dec 14, 2004 4:57 pm

Thanks a lot. One more clarification. "First line is column names" in the Output\Format tab means that while reading the sequential file it will ignore the first record and start the data processing from the second record. Am I correct?

Thanks and Regards,
-Sumit

chulett · Post by **chulett** » Tue Dec 14, 2004 4:59 pm

Actually, in a way, both are correct...

1) True when reading a sequential file with the option checked... even if the first record isn't column headings!

2) True when writing to a sequential file with the option checked and the file either doesn't exist or is being overwritten. If you are appending to the end of an existing file, no column headings are added.

sumitgulati · Post by **sumitgulati** » Tue Dec 14, 2004 5:21 pm

Thanks Craig.

-Sumit