using i-series nav, how to see results of query in text 1

[ddiamond]

I am using i-series navigator for the AS400 v5r4. When I run a query, it displays the results in a grid. Is there anyway to get it to display the results in text instead? This is useful when you are try to document your test results in text file. If this cannot be done with i-Series Navigator, is their another tool you can recommend?

 

[blom0344]

Personally I have always used the lite version of WinSQL.
Simply create a DSN with client Access ODBC, run the query from query panel (with display result as text). Select all and copy to a text editor.

Ties Blom

 

[ddiamond]

Thanks Ties. WinSQL did the trick.

 

[ddiamond]

Ties,

Do any WinSQL as400 plugins exist? I noticed they had plugins for DB2/UDB, but they don't work for the as400.

- Dan