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
How to get fieldnames of my source files
Moderators: chulett, rschirm, roy
Re: How to get fieldnames of my source files
Hi,
There's no need of a routine. You can import the file through DS Manager.
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.
Hi ArndW
Hi
Thanks for your reply
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
Thanks for your reply
But my question is that not importing metedata.My job is like thisArndW wrote: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. ...
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.