How to get fieldnames of my source files

[mohanraj]

Hi

Can anyone explain me how can I get metadata of my source file.I mean is there any prebuilt routine which will give me all the fields of my source file or is there anyother way by which I can capture my source file fields.

Thanks in advance
mohanraj

[ArndW]

Only if your file has the field names in the first line will this work. You can import this from the manager using the sequential file metdata import.

[meena]

Hi,
There's no need of a routine. You can import the file through DS Manager.

Can anyone explain me how can I get metadata of my source file.I mean is there any prebuilt routine which will give me all the fields of my source file or is there anyother way by which I can capture my source file fields.

[mohanraj]

Hi
Thanks for your reply

Only if your file has the field names in the first line will this work. You can import this from the manager using the sequential file metdata import. ...

But my question is that not importing metedata.My job is like this

Seq---->Transformer---->OCI
-
-
OCI

I mean two OCI stages populating from transformer
My problem is I need to collect all the fieldnames in transformer so that I can hardcode some value if my source column is null.So my question is that is there any prebuilt routine is there which will give me all the fields names of the source file.
And also I need to use this routine for the similar kind of jobs to get their respective source file fields

Thanks once again and waiting for your reply

Regards
Mohan

[ArndW]

Mohan,

you cannot dynamically assign column names at runtime the way you envision it in DataStage server jobs.

[ray.wurlod]

There are built-in Transforms such as NullToEmpty and NullToZero that you can use. These ought to serve as a useful starting point. You need to import/create the table definition for the output link of the Transformer stage; server jobs do not have runtime column propagation.