Parameter
rsdb/prefer_in_itab_opt

Short text
set if IN (...) shall be used for FOR ALL ENTRIE

Parameter description
This parameter is only intended for internal use and must not be changedwithout explicit instruction from SAP.
An internal table [itab] with entry data is always returned to an ABAPSELECT query with the addition FOR ALL ENTRIES. If this parameter is setto "1" then a statement refers to a statement with an IN clause whereonly one field in the WHERE clause depends on the internal table thatwas copied. However this is only possible if the field reference andWHERE condition are sufficiently simple. In effect, the field referencemust deal with a non-negated EQ condition.
Example
If the parameter rsdb/prefer_in_itab_opt is set to "1", then the openSQL statement
SELECT ... FOR ALL ENTRIES IN itab WHERE f = itab-f.
maps the following SQL statement
SELECT ... WHERE f IN (itab[1]-f, itab[2]-f, ..., itab[N]-f)

Work area
Database

Parameter unit
1 / 0

Default value
The default value is database-dependent. A common, artifical value (-1)must be specified for technical reasons. The original default values arespecified below for each database system. Caution: As these values arechanged by kernet patches, take the current default values from SAP Note48230.
DB2/390
1
DB2 UDB
1
Informix
1
iSeries
1
MaxDB
1
MS SQL Server
1
Oracle
1

Other parameter
No