Parameter
dbs/db4/dbsl_tablehint0
Short text
First conditional statement hint
Parameter Description
The parameter can be used to specify conditions under which an SQL statement hint shall be applied implicitly, without having to determine and modify the relevant ABAP statements.
Conditions can, be a table name, the number of parameter markers in a statement, settings of certain other profile parameter values, et. al.
Conditional Statement Hints have the following format:
predicate ? sethintexp
Example:
Distribute all statements for table ZTAB with no ABAP statement ID that have more than 12 parameter markers across 5 SQL packages.
dbs/db4/dbsl_tablehint0 = Table = ‘ZTAB’ & NoSTMTID = true & nMarkers >= 12 ? PackageDispersion = 5
For documentation of the complete syntax and more usage examples, see SAP Note 1109771.
Application Area
Database
Default Value
blank
Who is permitted to make changes?
DB administrator
Database System Restrictions
The parameter is only evaluated on DB2 for IBM i.
Are other parameters affected or dependent?
dbs/db4/dbsl_tablehint1 is not recognized if dbs/db4/dbsl_tablehint0 is not defined.
Values allowed
String following the conditional statement hint syntax
