I am runnig db2 9.7 on Vista

I want to send the output of a query from the CLP to a file in a specific directory

However if I put a backslash in the file redirect i get an error
example: select * from table1>C:mydir\output.txt

Also I do not seem to be able to set the DB2OPTIONS on

example: -r (save output to a report file) is set to off - i cannot set it on
what command do i need to use to change the default

Look for "UPDATE COMMAND OPTIONS" in the manual.

Andy

Use a forward slash. That's the path separator on unix systems, and Windows understands that as well.

On the CLP command line

to get output to file from windows vista
!db2 connect to stage1 user blue using xxxx;
!db2 select * from stag1.grade > "l:boots\testx.txt"

I think Howardw tries to redirect query output from within CLP, so no amount of slashes will help.

@Howardw, this can be done from the command line:

db2 "select * from table1">C:\mydir\output.txt

or

db2 -r C:\mydir\output.txt "select * from table1"