How do I get SQL output to a file on AS400?

[SkiLift]

I tried going into strsql and doing F13. From there I select 1, change session attributes. Then, I select output to file... I do a select statement and the output goes to the file. The problem is, I dont get column names and the numeric data is garbage (being print as chars)

How do I get proper output of a
select * from xyz
to a file?

 

[blom0344]

Use Client Access and perform a file transfer or use the ODBC drivers to set up a connection and use Excel / Access to download the data.....

T. Blom
Information analyst
tbl@shimano-eu.com

 

[leveyp]

Have a look at Query Manager Queries. STRQMQRY. You can code and de-bug interactively and then re-direct output to a DB2 table.