Ansicht
Dokumentation

rsdb/prefer_fix_blocking - Set if fix blocking for FOR ALL ENTRIES is desired

rsdb/prefer_fix_blocking - Set if fix blocking for FOR ALL ENTRIES is desired

Addresses (Business Address Services)   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.
SAP E-Book
------------------------------------------------------------------------
| Parameter : rsdb/prefer_fix_blocking |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Short description: Set if fix blocking for FOR ALL ENTRIES is desir |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Parameter description : |
| ----------------------- |
| This parameter is for internal use only and must never be |
| changed without the prior consent of SAP. |
| |
| An internal table [itab] with input data is always transferred in |
| case of an ABAP SELECT request with the addition FOR ALL ENTRIES. |
| If the number of entries in [itab] is not divisible by the maximum |
| blocking factor (that is max_(in_)blocking_factor or the technical |
| blocking factor limit), a smaller number of entries (conditions) is |
| assigned to the last statement that is generated for the processing |
| of the FOR ALL ENTRIES statement. This creates a new statement. |
| |
| If the same FOR ALL ENTRIES statement is used very frequently with a |
| different number of entries in the input table [itab], different |
| statements up to the maximum blocking factor are created. |
| |
| You can avoid this by setting this parameter. If this parameter is |
| set to "1", a maximum of two statements of different lengths are |
| generated. This is ensured by repeating the last entry in the input |
| table as though [itab] had been implicitly filled to the blocking |
| factor ([itab] is not actually modified). |
| |
| |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Application area: Database |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Unit : 1 / 0 |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Default value: |
| The default value is database-dependent. For technical reasons, it |
| is unfortunately necessary to enter a common, artificial value (-1). |
| The original default values for each database system are listed
| below. Caution: Since these values can be changed by kernel patches, |
| it is important that you obtain the current default values from SAP |
| Note 48230. |
| |
| DB2/390: 1 |
| DB2 UDB: 0 |
| Informix: 0 |
| iSeries: 1 |
| MaxDB: 0 |
| MS SQL Server: 0 |
| Oracle: 0 |
| |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Who is permitted to make changes: |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Limitations for operating systems: |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Limitations for database systems: |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Other Parameters Affected or Dependent: |
| rsdb/max_blocking_factor, rsdb/max_in_blocking_factor |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Valid Input, Formats, Areas: |
------------------------------------------------------------------------

------------------------------------------------------------------------
| Short Description : Set if fix blocking for FOR ALL ENTRIES is desired
------------------------------------------------------------------------

------------------------------------------------------------------------
| Applications Area : Database
------------------------------------------------------------------------

------------------------------------------------------------------------
| Parameter Type : I
------------------------------------------------------------------------

------------------------------------------------------------------------
| Changes allowed : X
------------------------------------------------------------------------

------------------------------------------------------------------------
| Valid for Operating System : *
------------------------------------------------------------------------

------------------------------------------------------------------------
| Dynamic switchable : X
------------------------------------------------------------------------

------------------------------------------------------------------------
| Same on all Servers : X
------------------------------------------------------------------------


CL_GUI_FRONTEND_SERVICES - Frontend Services   Vendor Master (General Section)  
This documentation is copyright by SAP AG.

Length: 7051 Date: 20240328 Time: 110834     sap01-206 ( 6 ms )