Sequential Stage in PX

srikanthd1978 · Post by **srikanthd1978** » Fri Jul 01, 2005 1:56 pm

hi all,

may seem like a Duh! Question..but i was wondering..

How we can specify in a Sequential file Stage that the First Line in the input file is Column Names...i know in Server Job....How about in PX?

thanks,
srikanth.

pnchowdary · Post by **pnchowdary** » Fri Jul 01, 2005 2:28 pm

Hi srikanth,

Even in PX jobs, the sequential file stage has an item under options ( First Line is Column Names ). It can be either set to TRUE or FALSE. In your case, you would set it to TRUE.

srikanthd1978 · Post by **srikanthd1978** » Fri Jul 01, 2005 2:35 pm

pnchowdary wrote:Hi srikanth,

Even in PX jobs, the sequential file stage has an item under options ( First Line is Column Names ). It can be either set to TRUE or FALSE. In your case, you would set it to TRUE.

I do not see any such option in PX Sequential stage...

pnchowdary · Post by **pnchowdary** » Fri Jul 01, 2005 3:08 pm

What version of datastage are you using?. I am using version 7.5 and I see that option in the sequential file stage on the ouput -> properties tab. Maybe the DS gurus can tell us more.

ray.wurlod · Post by **ray.wurlod** » Fri Jul 01, 2005 7:31 pm

That property does not appear to be visible in 7.1, but you can specify "first line is column names" in the format when importing the Sequential File table definition. Loading it from the Repository into the job design should preserve this property.