Query files and tools

The Open Query File (OPNQRYF) command can retrieve or perform the selection of Unicode data. IBM® Query for i, DB2® Query Manager, and IBM i DB2 Query Management all have Unicode support.

Open query file (OPNQRYF) command considerations

The Open Query File (OPNQRYF) command, shown as follows, can retrieve or perform selection of Unicode data. Using the MAPFLD parameter, data can be mapped to or from Unicode.

OPNQRYF FILE(U_TABLE)
QRYSLT('NAME=MAPNAME')
MAPFLD((MAPNAME 'John Doe' *GRAPHIC *N *N 1200))

Interactive query tools considerations

IBM Query for i, DB2 Query Manager, and IBM i DB2 Query Management all have Unicode support. Unicode data can be displayed or printed on a report by implicitly converting to either character or mixed art.