copy query results into text file

kenare · #1 (**permalink**) 12-03-03, 05:35

I am using DB2 v8.1 on windows 2000.
If the records are there then I am able to copy the query results into text file using Query Results -> save data -> as text from command center. But the output of the query is of zero records then copy option is disabled. Even if there are no records then also I need to have a text file with the table name. Is there any other way to generate a text file with or without data from the query?

Thanks in advance
kenare

sathyaram_s · #2 (**permalink**) 12-03-03, 05:58

You can use EXPORT

Cheers
Sathyaram

Quote:

Originally posted by kenare
I am using DB2 v8.1 on windows 2000.
If the records are there then I am able to copy the query results into text file using Query Results -> save data -> as text from command center. But the output of the query is of zero records then copy option is disabled. Even if there are no records then also I need to have a text file with the table name. Is there any other way to generate a text file with or without data from the query?

Thanks in advance
kenare

kenare · #3 (**permalink**) 12-03-03, 07:51

Hi Sathyaram,

Thank you. My problem solved

Kenare

Internet Services

Web Development

Digital Marketing

Consumer Tech