Hi,
Is there a way to generate columns dynamically?
If suppose, i have input files like:
file 1:
col1,col2,col3,col4
file 2:
col1,col2,col3,col4,col5
file 3:
col1,col2,col3,col4,col5,col6.
If the datatypes of all files are same, then can i use a single job for handling all the three input files?
please suggest..
Thanks,
Savis
Generate columns dynamically
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The easiest complete approach is to use the Schema File property in the Sequential File stage, and set is value to a file that properly represents the record schema of the file that the generic job processes.
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.