SAP Parameter rsdb/max_in_blocking_factor - Max. split factor for FOR ALL ENTRIES queries (IN opt)

Parameter
rsdb/max_in_blocking_factor

Short text
Max. split factor for FOR ALL ENTRIES queries (I

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. This parameter returnsan upper limit for the numer of entries to be processed that matchesrsdb/max_blocking_factor from [itab] for the case that the actualstatement to an IN clause is displayed (see rsdb/prefer_in_itab_opt).
The same as for rsdb/max_blocking_factor, the bloacking factor limit isused instead of rsdb/max_in_blocking_factor, otherwise the upper limitsof the database systems are exceeded.

Work area
Database

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
10
DB2 UDB
60
Informix
50
iSeries
40
MaxDB
254 (non-Unicode) or 127 (Unicode)
MS SQL Server
255
Oracle
5

Other parameter
rsdb/prefer_in_itab_opt