What is Reason code 11 in R/INCOMPTS SQL Incompatibility Summary IFCID 376

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

In R/INCOMPTS SQL Incompatibility Summary (IFCID 376) Item 1-7/7 the following was displayed.

Rsn SQL Last executed 
Incompatibility reason Code Count Stmt ID (HEX) Last exec 

CHAR(dec) Format 1 16 000000000003FF02 10/25/18 09:40:01 
VARCHAR/CAST(dec) Format 2 2 00000000013298C4 10/23/18 09:44:18 
QW0376FN Unknown Type 11 399 00000000017F769F 10/25/18 09:56:48 
Long CLIENT_ACCTNG SR 1104 25 0000000000040DB8 10/25/18 11:41:48 
Long CLIENT_APPLNAME SR 1105 25 0000000000040DB8 10/25/18 11:41:48 
Long CLIENT_USERID SR 1106 25 0000000000040DB8 10/25/18 11:41:48 
Long CLIENT_WRKSTNNAME 1107 25 0000000000040DB8 10/25/18 11:41:48 

To identify the IFCID 376 Incompatibility SQL codes, the reason codes are provided from 1 to 10. What is then  reason = "QW0376FN Unknown Type" and Reason code = "11"?
 

Resolution

Reason code 11 is SELECT INTO with UNION. This is  found in  the  most recent version of the DECLARE in IQL member DCL$A$D: DECLARE APPL-SQL-INCOMPAT REASON (A25) VALOF IF SYSIBM-CHAR-FUNC = 1 RESULTIS 'CHAR(dec) Format' ELSEIF SYSIBM-CHAR-FUNC = 2 RESULTIS 'VARCHAR/CAST(dec) Format' ELSEIF SYSIBM-CHAR-FUNC = 3 RESULTIS 'Unsupported Timestamp' ELSEIF SYSIBM-CHAR-FUNC = 4 RESULTIS 'DB2 10 default SQL path' ELSEIF SYSIBM-CHAR-FUNC = 5 RESULTIS 'CUBE unqual UDF name' ELSEIF SYSIBM-CHAR-FUNC = 6 RESULTIS 'ROLLUP unqual UDF name' ELSEIF SYSIBM-CHAR-FUNC = 7 RESULTIS 'Incompatible conversion' ELSEIF SYSIBM-CHAR-FUNC = 8 RESULTIS 'Match CALL statement' ELSEIF SYSIBM-CHAR-FUNC = 9 RESULTIS 'Ignore the TIMEZONE part' ELSEIF SYSIBM-CHAR-FUNC = 10 RESULTIS 'Pre-V10 LTRIM/RTRIM/STRIP' ELSEIF SYSIBM-CHAR-FUNC = 11 RESULTIS 'SELECT INTO with UNION' ELSEIF SYSIBM-CHAR-FUNC = 1101 RESULTIS 'INSERT w/o XMLDOCUMENT' ELSEIF SYSIBM-CHAR-FUNC = 1102 RESULTIS 'XPath evaluation error' ELSEIF SYSIBM-CHAR-FUNC = 1103 RESULTIS 'RLF governing' ELSEIF SYSIBM-CHAR-FUNC = 1104 RESULTIS 'Long CLIENT_ACCTNG SR' ELSEIF SYSIBM-CHAR-FUNC = 1105 RESULTIS 'Long CLIENT_APPLNAME SR' ELSEIF SYSIBM-CHAR-FUNC = 1106 RESULTIS 'Long CLIENT_USERID SR' ELSEIF SYSIBM-CHAR-FUNC = 1107 RESULTIS 'Long CLIENT_WRKSTNNAME' ELSEIF SYSIBM-CHAR-FUNC = 1108 RESULTIS 'Long client RLF SR value' ELSEIF SYSIBM-CHAR-FUNC = 1109 RESULTIS 'CAST(string AS TIMESTAMP)' ELSEIF SYSIBM-CHAR-FUNC = 1110 RESULTIS 'SPACE int greater 32764' ELSEIF SYSIBM-CHAR-FUNC = 1111 RESULTIS 'VARCHAR int greater 32764' ELSEIF SYSIBM-CHAR-FUNC = 1112 RESULTIS 'Empty XML elem as ' ELSEIF SYSIBM-CHAR-FUNC = 1201 RESULTIS '-802 result out of range' ELSEIF SYSIBM-CHAR-FUNC = 1215031 OR = 1202 RESULTIS 'Temporal query' ELSEIF SYSIBM-CHAR-FUNC = 1215032 OR = 1203 RESULTIS 'CALL SP for replication' ELSE RESULTIS 'QW0376FN Unknown Type' IFEND