How to include Header row in sequential file

[bsreenu]

Hi,

Can someone please tell me How to include header row while wiriting into a sequential flat file.


Ex: The seq. file should be look like this

EMPNO|EMPNAME|DEPT
123|JOHN XYZ|150
234|XYX ABC|201

I'm able to create and write data into seq. file, but the header is missing. Is there any option in "seq file stage" to include header row.
Please let me know if there any other alternates.

I appreciate your help.

[phanee_k]

In the format tab of Sequential File in Input tab , select the check box against " First Line is Column Names " and run the job.

HTH

[Someswar Barkataki]

That is true for server jobs. Phanee, could you explain how we set that for parallel job?

Thanks,
Somesh

[ray.wurlod]

Perhaps a before-job subroutine to write the header, then your Sequential File stage appends to the existing file.

[sjordery]

We try to write a small job which uses a row generator to a file, and then in the second job in the sequence, we just append to the existing file. this works well for all cases where you need some text before the value and will work for header columns as well - you just define the header column as a varchar string and in the derivation, just put this string...

[ray.wurlod]

In the parallel Sequential File stage the "First line is header rows" property is a General property, not a Format property. On the Properties tab you will find it in the Options folder.