Extract data from db2 table with column name

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?

PeD · Posted: Wed Jun 18, 2008 1:37 pm Post subject:

DSNTEP2 aka SPUFI in batch

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.

Gnanas N · Posted: Fri Jun 20, 2008 7:15 pm Post subject:

These are other options on QMF.