Db2 may abend or generate 901 when the following conditions are
met:
1) The query has one or more subqueries
2) There is an xmlcolumn in one of the subquerries
3) There is no reference of the xmlcolumn in the main query.
Example:
CREATE TABLE TABKVER (
BKVER_VGN SMALLINT NOT NULL,
BKVER_GUEL_AB_DT CHARACTER(20 OCTETS) NOT NULL);
WITH KFZ_VERTRAG AS (
SELECT x1. *, XMLCAST(XMLQUERY('string($D) castable as
xs:date' PASSING x1.BKVER_GUEL_AB_DT AS D) AS VARCHAR(100)) AS
BKVER_GUEL_AB_DT_AS_DATE FROM TABKVER x1 ),
STICHTAGE( STICHTAG) AS
(SELECT DATE('2014-01-01') AS STICHTAG FROM
SYSIBM.SYSDUMMY1),
KFZ_VERTRAG_MAX_SEGMENT AS
(SELECT D.STICHTAG,MAX(V.BKVER_VGN) AS MAX_VGN FROM
KFZ_VERTRAG V,STICHTAGE D GROUP BY D.STICHTAG),
KFZ_VERTRAG_FILTER_MAX_SEGMENTE AS
(SELECT MS.STICHTAG FROM KFZ_VERTRAG KVV,
KFZ_VERTRAG_MAX_SEGMENT MS)
SELECT * FROM KFZ_VERTRAG_FILTER_MAX_SEGMENTE KMV;
the stack looks like:
box_copy__9sqlnq_qtbFPP9sqlnq_qtbP9sqlnq_quriN43bT8
sqlns_deep_box_copy__FP9sqlnq_qtbP9sqlnq_qunRP9sqlnq_qtbCiT4PFP9
sqlnq_qunPUcRiRPP9sqlnq_qunT4PP9sqlnq_qunT6RP12sqlnq_colmapT3_iP
UcbiN28
sqlns_graph_copy__FP9sqlnq_qunCiN22PCiiT2PFP9sqlnq_quniPUcRi_iPU
cPFP9sqlnq_qunPUcRiRPP9sqlnq_qunT4PP9sqlnq_qunT6RP12sqlnq_colmap
T3_iT9bT12_T6N212_ + 0x8D0
sqlnq_copy_box_and_correlation__FP9sqlnq_qtbP9sqlnq_qunCiiRP9sql
nq_qtbN24bT8 + 0x470
sqlnr_break_cse_box__FP9sqlnq_qtbPii + 0xBDC
sqlnr_selucom_action__FP10sqlnr_qrwaPiP14sqlnr_progress + 0x1A0
sqlnr_comp__FPiiP16sqlnr_rule_stateP10sqlnr_qrwaP14sqlnr_progres
s + 0x474
sqlnr_seq__FPiP10sqlnr_qrwaP14sqlnr_progressP12sqlnr_rclass +
0x1D8
sqlnr_rcc__FiP10sqlnr_qrwaPiP14sqlnr_progress + 0x1B4
sqlnr_perqun_action__FP10sqlnr_qrwaPiP14sqlnr_progress + 0x164
sqlnr_comp__FPiiP16sqlnr_rule_stateP10sqlnr_qrwaP14sqlnr_progres
s + 0x474
sqlnr_priority__FPiP10sqlnr_qrwaP14sqlnr_progressP12sqlnr_rclass
+ 0x158
sqlnr_rcc__FiP10sqlnr_qrwaPiP14sqlnr_progress + 0x1FC
sqlnr_allqun_action__FP10sqlnr_qrwaPiP14sqlnr_progress + 0x1F8
sqlnr_comp__FPiiP16sqlnr_rule_stateP10sqlnr_qrwaP14sqlnr_progres
s + 0x474
sqlnr_seq__FPiP10sqlnr_qrwaP14sqlnr_progressP12sqlnr_rclass +
0x1D8
sqlnr_rcc__FiP10sqlnr_qrwaPiP14sqlnr_progress + 0x1B4
sqlnr_start_action__FP10sqlnr_qrwaPiP14sqlnr_progress + 0x55C
sqlnr_comp__FPiiP16sqlnr_rule_stateP10sqlnr_qrwaP14sqlnr_progres
s + 0x474
sqlnr_seq__FPiP10sqlnr_qrwaP14sqlnr_progressP12sqlnr_rclass +
0x1D8
sqlnr_rcc__FiP10sqlnr_qrwaPiP14sqlnr_progress + 0x1B4
sqlnr_exe__FP9sqlnq_qur + 0xBF0
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_enviT7PP9sqlnq_qur + 0x63AC
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_env + 0x64
sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P14SQLP_
LOCK_INFOP16sqlra_cached_varPiT11_Pb + 0x1F30
sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi
T4PUcT4UsUcP14sqlra_cmpl_env15sqlra_fill_modePiiT12_N313_T12_P14
SQLP_LOCK_INFOPP16sqlra_cached_varT12_bT19_Pb + 0x101C
sqlra_get_var__FP8sqlrr_cbiT2bPbT5 + 0x2920
sqlrr_prepare__FP14db2UCinterfaceP16db2UCprepareInfo + 0x42C
sqljs_ddm_prpsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0x20C
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface + 0x288
sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
0x290
sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x6CC
sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x1D0
sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x59C
sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0x2EC
RunEDU__8sqeAgentFv + 0x46C
EDUDriver__9sqzEDUObjFv + 0x23C
sqlzRunEDU__FPcUi + 0x3C
sqloEDUEntry + 0x7B4 |
