SQL query output to a CSV file

dba_udb · #1 (**permalink**) 02-28-08, 18:06

UDB v8.11

All-

How do i send the out put of sql QUERY TO A CSV file. This is an urgent requsst . And any help is appreciated.

thanks

ugrasena · #2 (**permalink**) 02-28-08, 21:01

Try this
Writing to a OutFile from command ine from the c prompt
db2 -z c:/xxx.xls SELECT * FROM tablename

ARWinner · #3 (**permalink**) 02-29-08, 03:03

Quote:

Originally Posted by dba_udb

UDB v8.11

All-

How do i send the out put of sql QUERY TO A CSV file. This is an urgent requsst . And any help is appreciated.

thanks

Look at the EXPORT command.

Andy