Export data from DB2 (MAINFRAME) table into flat file
Moderators: chulett, rschirm, roy
Export data from DB2 (MAINFRAME) table into flat file
How do I export data from DB2 (MAINFRAME) table into flat file from command line without creating datastage job? Source and target will be specified on command line to dsjob. I'm expecting datastage should pick up table layout (metadata) from source parameter. Is it possible? Is there any other quick way to dump data from source tables into flat file?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It's not possible.
You want to do something without creating a DataStage job and get it to happen via dsjob, the command that runs DataStage jobs? The question is internally inconsistent.
Further, DataStage is metadata-driven; there is no out-of-the-box mechanism for handling metadata dynamically. You can, of course, write your own routines for this, but you'd still need a separate DataStage job for each possible combination of column definitions.
DataStage does not support creating jobs "on the fly", though there is - or used to be - an API for doing so. But you have to write them yourself.
You want to do something without creating a DataStage job and get it to happen via dsjob, the command that runs DataStage jobs? The question is internally inconsistent.
Further, DataStage is metadata-driven; there is no out-of-the-box mechanism for handling metadata dynamically. You can, of course, write your own routines for this, but you'd still need a separate DataStage job for each possible combination of column definitions.
DataStage does not support creating jobs "on the fly", though there is - or used to be - an API for doing so. But you have to write them yourself.
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.