Page 1 of 1
Sequential Stage in PX
Posted: Fri Jul 01, 2005 1:56 pm
by srikanthd1978
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.
Posted: Fri Jul 01, 2005 2:28 pm
by pnchowdary
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.
Posted: Fri Jul 01, 2005 2:35 pm
by srikanthd1978
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...
Posted: Fri Jul 01, 2005 3:08 pm
by pnchowdary
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.
Posted: Fri Jul 01, 2005 7:31 pm
by ray.wurlod
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.