Symptom
This problem happens when an INSERT statement is executed with "WITH" clause.
"WITH" clause is to define one or more common table expressions, also known as temporary views, to be used elsewhere in the remainder of the statement.
[Abort thread stack]
.hos_ABORT(...................................
.SigHndlr+0x54()
.QOG::addIfOuterReference(...................................
.QOG::FindViewColumn(...................................
.dfe_Builder::DoBuildViewColumn(...................................
.dfe_Builder::FactFun_E_VIEW_COLUMN(...................................
.dfe_FactoryStaticMethod::PreBuildAndArgs(...................................
.dfe_Factory::BuildAndArgs(dfe_Builder*,...................................
.dfe_Builder::BuildPrepExpr(...................................
.dfe_Builder::FactFun_E_DOT_REF(dfe_Builder*,...................................
.dfe_Builder::FactFun_E_DOT_REF(dfe_Builder*,...................................
.dfe_FactoryStaticMethod::PreBuildAndArgs(dfe_Builder*,...................................
.dfe_Factory::BuildAndArgs(dfe_Builder*,...................................
.dfe_Builder::BuildPrepExpr(...................................
.dfe_Builder::BuildArgs(...................................
.dfe_Factory::PreBuildAndArgs(dfe_Builder*,...................................
.dfe_FactoryPredCmp::PreBuildAndArgs(dfe_Builder*,...................................
.dfe_Factory::BuildAndArgs(dfe_Builder*,...................................
.dfe_Builder::BuildPrepExpr(...................................
.dfe_ExprBuilder::BuildFinalPrepExpr(...................................
.dfe_DFPBuilder::MakeConjunct(...................................
.DE_BuildRestricts(qog_DTB*,...................................
.qog_DTBSelect::BuildExpressions(QueryNode*,qog_OuterEdge*,...................................
.qog_DTBSelect::BuildExpressions()+...................................
.qog_Quantifier::BuildExpressions()+...................................
.qog_DTBSelect::BuildDerivedColumns()+...................................
.QOG::Build()+...................................
Read more...
Environment
- SAP IQ 15.4
- SAP IQ 16 SP01
Product
Keywords
with clause, CR 744246, CR 724532 , KBA , BC-SYB-IQ , Sybase IQ , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.