I have a flat file that has table name and then 2 other columns. In odbc input columns i am getting all three columns.
Now i want to write insert query to pick up table name as column 1 value and the rest 2 columns would be inserted as values in the table.
odbc inset query dynamic table name from input column
-
- Participant
- Posts: 3
- Joined: Mon Aug 14, 2006 12:12 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard. :D
Please verify that you want to perform this task using DataStage TX (transformation extender), which we have assumed since you have posted in the DataStage TX forum.
Otherwise please post the question in the Parallel forum.
Please verify that you want to perform this task using DataStage TX (transformation extender), which we have assumed since you have posted in the DataStage TX forum.
Otherwise please post the question in the Parallel forum.
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.