SAP Note 1109771 - DB4: Conditional Statement Hints

Component : DB2 for AS/400 - IBM AS/400

Solution : https://service.sap.com/sap/support/notes/1109771 (SAP Service marketplace login required)

Key words :
<variable>        --> <hint>                  --> queryclass                  --> table                  --> nostmtid                  --> module                  --> nmarkers                  --> operation                  --> haslobs<hint>            --> singleexecution                  --> singleexecutionreuse                  --> singleexecutioncached                  --> alternateinilib                  --> hardclose                  --> packagedispersion<, /usr/sap/<sid>/sys/profile/<sid>_d<inst>_<host>, ><sethintexp>      --> <sethintexp> <booleanop> <hintclause>                  --> <hintclause><hintclause>      --> <variable> <equalsign> <, <predicate>       --> <predicate> <boolop><predicateclause>                  --> <predicateclause><predicateclause> --> <variable> <compareop> <, /infocenter/iseries/v5r4/topic/rzajq/qryopt, > ->        --> true                  --> false                  --> <word>                  --> <number><number>          --> [0-9]+<word>            --> [a-, alternateinilib = false & hardclose = true queryclass = infocube, singleexecutiondbs/db4/dbsl_tablehint1 = table = 'sflight' & singleexecution, table = 'abc def' & nmarkers >= 12 & singleexecution = true, singleexecutionreuse = true module = 'bw slow'

Related Notes :

1536572DB4: SQL Package Dispersion to Increase Statement Limits
1109573DB4: Auto SingleExecution for Package Overflow
972460DB4: Alternate SQL Packages
485420iSeries: Database hints for Open SQL/Native SQL
54028IBM i: SQL0 904 reason code 7, overflow in SQL package