Parameter
rsdb/max_blocking_factor

Short text
Split factor for FOR ALL ENTRIES queries

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. The profile parametersets the upper limit for the amount of entries from [itab] to beprocessed in a statement That is, if the internal table included in theFOR ALL ENTRIES clause contains more than rsdb/max_blocking_factorlines, the Open SQL statement is divivded up into multiple statementswith regard to the database whose individual results are collected inthe DB interface and then returned as a total result to the ABAPprogram. For an internal table with N lines, with regard to the database
N / "rsdb/max_blocking_factor" + 1
individual SELECT statements are issued. This parameter however does nothave any effect in the construction of IN (...) - see the documentationon rsdb/prefer_in_itab_opt.
The technical maximim blocking factor is calculated for each statementso that no database system limits are exceeded. If the flocking factorlimit is less than max_blocking_factor then this limit is implicitlyused.

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
10
Informix
20
iSeries
20
MaxDB
10
MS SQL Server
50
Oracle
15

Other parameter
rsdb/prefer_in_itab_opt