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 changed without explicit instruction from SAP.
An internal table [itab] with entry data is always returned to an ABAP SELECT query with the addition FOR ALL ENTRIES. This parameter returns an upper limit for the number of entries to be processed that matches rsdb/max_blocking_factor from [itab] for the case that the actual statement to an IN clause is displayed (see rsdb/prefer_in_itab_opt).
The same as for rsdb/max_blocking_factor, the blocking factor limit is used instead of rsdb/max_in_blocking_factor, otherwise the upper limits of the database systems are exceeded.
Application Area
Database
Default Value
The default value is database-dependent. A common, artificial value (-1) must be specified for technical reasons. The original default values are specified below for each database system. Caution: As these values are changed by kernel patches, take the current default values from SAP Note 48230.
DB2/390
10
DB2 UDB
60
Informix
50
iSeries
40
MaxDB
254 (non-Unicode) or 127 (Unicode)
MS SQL Server
255
Oracle
5
Are other parameters affected or dependent?
rsdb/prefer_in_itab_opt
