Using db2 9.7 on windows vista

I have tried numerous ways to get the SQL output to a file

on db2 prompt=>!db2 select * from table >l:db2\sql.txt

in the file sql.txt i get
SQL1024N A database connection does not exist. SQLSTATE=08003

I have run the connect to database command and got the database connect information details

if i do
select * from table >l:db2\sql.txt

then the CLP gives the mesage "the command was processed as an sql statement etc"

What do i need to do to get the CLP to send the SQL output to the file ?

I would like to see the table data in the file from the select statement

Thanks

Look at the "UPDATE COMMAND OPTIONS" CLP command in the manual.

Andy

do not use the command prompt - use command window - there all rerout can be used
> outfile