|
View previous topic :: View next topic
|
| Author |
Message |
Richa Jain
New User
Joined: 18 Mar 2008
Posts: 35
Location: Gurgaon
|
|
|
|
I want to extract the data from a db2 table into a sequential file. I want db2 table column name as a header to the sequential file.
So is it possible to extract the data from db2 table into a sequential file with column names? |
|
| Back to top |
|
 |
PeD
Active User
Joined: 26 Nov 2005
Posts: 459
Location: Belgium
|
|
|
|
| DSNTEP2 aka SPUFI in batch |
|
| Back to top |
|
|
Richa Jain
New User
Joined: 18 Mar 2008
Posts: 35
Location: Gurgaon
|
|
|
|
I have got an answer of my question.
We can use QMF to extract the data into a sequential file with column names. Below are the setps -
Step 1: Write sql query in QMF screen
Step 2: Press F2 to run the query and to see the report.
Step 3: Write 'export report to '<datasetname>' and hit enter.
I hope it will be useful for others. |
|
| Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007
Posts: 792
Location: Chennai, India
|
|
|
|
These are other options on QMF.
| Code: |
DRAW SYSIBM.SYSTABLES --> Any table name here.., to get column list
EDIT QUERY --> To navigate to other panels
EXPORT DATA TO 'dataset'
IMPORT DATA FROM 'dataset'
SAVE QUERY AS TEMP --> I havn't used
RES |
|
|
| Back to top |
|
|
|
|
