Automate query output to .txt or .csv file

jjrenner · #1 (**permalink**) 10-04-05, 09:02

Good day!

What is the easiest most efficient way to output a query to a .txt or .csv?

JP

Peter.Vanroose · #2 (**permalink**) 10-04-05, 11:08

This depends on you OS (MS-Windows or UNIX or ...) and your DBMS (DB2 or Oracle or ...)
Essentially, in all cases, you may do something like

Code:

 DBMS  "SELECT * FROM table" > file.txt

where "DBMS" is the command to run the DBMS SQL interpreter from the command line.

jjrenner · #3 (**permalink**) 10-05-05, 06:54

Yes, I should probably included that info!

Windows Server 2003
SQL 2000

Thanks for the help!

JP