Query 400 Characters to Digits
How to convert numbers saved as characters into digits. Is there any Query instruction to convert Characters into Digits?  I’m trying to link 2 files, and one of the fields is character in one file and digits in the other, so I can’t link them.  For example:   00877874 is saved as character in file 1 [...]

Answer Question   |  May 4, 2010  2:05 PM
Query for OS/400

Display Query for OS/400 SQL script
Is it possible to view the SQL that is generated by a query created in Query for OS/400. I have the query defined as I want it and would now like to give the SQL script to my development team to use in automating reports by accessing the database directly.

Answer Question   |  May 19, 2009  3:15 PM
OS/400, OS/400 Query, Query for OS/400, SQL scripts