Open SQL - Database Notes - ABAP Keyword Documentation

ABAP - Keyword Documentation → ABAP - Reference → Processing External Data → ABAP Database Accesses → Open SQL →

Open SQL - Database Notes

Syntax

... %_HINTS db @dbhint1
[db @dbhint2
... ] ...

Effect

The addition %_HINTS can be used to specify database notes at the following positions in Open SQL statements:

After the clauses of SELECT statements in main and subqueries.

After the WHERE condition of the statements UPDATE and DELETE.

One or more database notes can be listed after %_HINTS as a blank-separated list in flat, character-like data objects dbhint1, dbhint2, ... . The name of host variables should be prefixed with the escape character @. The addition db must be used before each database note to specify the database system for which the note is intended. The following table shows the possible additions and the corresponding database system:

Addition	Database System
ADABAS	SAP MaxDB
AS400	IBM System i (AS/400)
DB2	IBM DB2
DB6	IBM DB2 UDB
HDB	SAP HANA database
MSSQLNT	Microsoft SQL Server
ORACLE	Oracle DB
SYBASE	Sybase ASE

A database system can be listed more than once if there are several database notes for this system. The possible database notes are database-specific and may depend on the release of the database system. They can be found in the documentation of the respective database system. An empty note is ignored.

If SAP buffering is used, or if pool or cluster tables are accessed, the specification of database notes is ignored.

Notes

A database note usually only affects the part of an Open SQL statement for which is it specified. It doesn't usually affect the functionality of a statement, but may affect performance.

Database notes should only be used with extreme caution. For example, they can be used as a last resort to influence the optimizer of the database system when selecting a secondary index.

If database notes are used, they should generally be checked every time the database release or system configuration is changed.

Database notes specified as literals are also not evaluated until runtime. If the syntax is incorrect, they can cause exceptions at runtime or are ignored. In the strict mode as of Release 7.51 only, statically known database notes are also checked statically.

Database notes of the database interface are intended for internal use only. These are put between & characters and are evaluated before they are transferred to the database system from the database interface.

In the strict modes of the syntax check from Release 7.40, SP05, the escape character @ must be before a note that is not specified as a literal.