Hi all,
I would like to know please how you can capture results of an SQL statement within DB2 into a flat file.

eg. select * from table >> file1

I can then look at the results of the SQL statement in "file1" as an example.

Thanks,
Adrian

command line :

db2 "select * from table " > file1.txt

Use the DB2 Command Window (Windows) or normal shell, not the DB2 shell. If using Windows, see your start menu for the DB2 Command Window. If using Linux/UNIX, just use normal shell (korn/bash, etc):

db2 "select * from table" > file1