|
|
| Author |
Message |
amitraja
New User
Joined: 13 Jan 2004
Posts: 12
|
|
|
|
Hi,
I am looking for a DB2 command which will give me the result and the coulmn name as well in the output.
Right now when I use QMF I just get the result of the query. If I want to get the COLUMN names back in the result set what would the command be ?? Or is there any set up I need to do ??
Suppose I am using the query from a cobol program I want a uery which will return the column name + the resulf of the query
Thanks
Ami |
|
| Back to top |
|
 |
References
|
 Posted: Wed Sep 29, 2004 4:09 am Post subject: Re: DB2 command -- syntax |
|
|
|
|
mmwife
Super Moderator
Joined: 30 May 2003
Posts: 1493
|
|
|
|
| Why don't you use SPUFI instead of QMF? SPUFI does just that. |
|
| Back to top |
|
|
amitraja
New User
Joined: 13 Jan 2004
Posts: 12
|
|
|
|
Hi,
thanks for the reply
I can use supify that's true but what I am accessing the DB2 database from other Cobol program. So I want it as an output in the result set.
Thanks
Amit |
|
| Back to top |
|
|
mmwife
Super Moderator
Joined: 30 May 2003
Posts: 1493
|
|
|
|
| You'll have to provide the column heads yourself in the pgm, likeyou'd do for any report printed from a COBOL pgm. |
|
| Back to top |
|
|
|
|
