Need help with setvar for iSeries query manager using not in ()
I have an issue with a Query Manager where I need help with the syntax for a list of entries in the Select not in ( ) portion. I have a command that will call an RPGLE module which will call the Query Manager. I know that the quotes have to be supplied by the [...]

Answer Question   |  November 29, 2010  9:43 PM
iSeries, Query Management Query, Query Manager, V5R2

Difference between QM Query and traditional query
When both a QM Query and a traditional Query are run against a database file with IDENTICAL record selection, the traditional query returns more records. I can only guess that it has to do with a difference in the way each utility handles uncommitted data. It almost looks as if traditional Query “sees” uncommitted changes whereas Query Manager [...]

Answer Question   |  September 29, 2010  7:01 PM
Database Files, Query, Query Management Query, Query Manager

Problem in CCSID converting
I have a QM query that forms up a DB file. A physical file. A file that afterwards will be tranferred to the excel worksheet. All the source DB files (as well as all the records inside) that I use in the QM query are having the CCSID=297 (french). But the data itself stored in [...]

Answer Question   |  January 22, 2009  5:09 AM
5250 session, AS/400, AS/400 import/export, CCSID, Change Physical File, CHGPF, Coded Character Set Identifier, DDS, iSeries Access for Windows, locale, Microsoft Excel, Physical File, QMQRY, Query Management Query, V5R3