error in column names

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
bunny
Participant
Posts: 10
Joined: Thu Apr 21, 2005 8:06 am
Contact:

error in column names

Post by bunny »

hi,

i am extracting tab delimited source file using sequential file stage. but in sequentail file out put ,under columns tab

columns names appearing as
filed001,
fileld002,

,,,,


filed047. it is not displaying actual column names, what might be the reason.

thanks
ds_developer
Premium Member
Premium Member
Posts: 224
Joined: Tue Sep 24, 2002 7:32 am
Location: Denver, CO USA

Post by ds_developer »

Does the file have a header row? If it does, it can use those names. Otherwise, it has to generate the field names.

John
jmorgan
Participant
Posts: 10
Joined: Thu Mar 10, 2005 7:29 pm
Location: Brisbane, Australia

Post by jmorgan »

You can then substitute your own column names on the Define tab when importing the Sequential File definitions. Or check the "first line is column names" check box if that is the appropriate course. DataStage can not read your mind!
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

You may have to modify the column metadata to confirm to the source.
Post Reply