EXPLAIN Unicode support

You can use DB2® EXPLAIN to capture access path information for your queries. Start of change This information is stored in the DB2 EXPLAIN tables, which are encoded in UTF-8. End of change

Begin program-specific programming interface information.

Start of change Before you migrate to DB2 10, you must migrate any existing EBCDIC EXPLAIN tables to the current release format and then to Unicode. In previous releases of DB2, EXPLAIN tables were encoded in EBCDIC by default. End of change

Start of change When you retrieve data from the EXPLAIN tables, be aware that the data is encoded in UTF-8. End of change

The following EXPLAIN table columns store encoding and CCSID information:

PLAN_TABLE columns:

TABLE_ENCODE: Indicates the encoding scheme of the statement. If the statement represents a single CCSID set, the column contains 'E' for EBCDIC, 'A' for ASCII, or 'U' for Unicode. If the statement is a multiple CCSID set statement, the column is set to 'M' for multiple CCSID sets.
TABLE_SCCSID: Contains the SBCS CCSID value of the table or zero if the TABLE_ENCODE column is 'M.'
TABLE_MCCSID: Contains the Mixed CCSID value of the table or zero if the TABLE_ENCODE column is 'M.'
TABLE_DCCSID: Contains the DBCS CCSID value of the table or zero if the TABLE_ENCODE column is 'M.'

DSN_STATEMNT_TABLE column:

STMT_ENCODE: Indicates the encoding scheme of the statement. If the statement represents a single CCSID set, the column contains 'E' for EBCDIC, 'A' for ASCII, or 'U' for Unicode. If the statement is a multiple CCSID set statement, the column is set to 'M' for multiple CCSID sets.

End program-specific programming interface information.