ABAP Keyword Documentation →  ABAP - Release-Specific Changes →  Changes in Release 7.0 and its EhPs →  Changes in Release 7.0, EhP2 

Database Access in Release 7.0, EhP2

1. UPDATE for tables with strings

2. SAP buffering for single record accesses

3. Short strings as key fields of database tables

4. Maximum length of short strings in ABAP Dictionary

5. ABAP Database Connectivity (ADBC)

6. Streaming and locators in Open SQL

7. Specifying sorting columns in Open SQL

8. Overflow handling for sy-dbcnt

Other versions: 7.31 | 7.40 | 7.54

Modification 1

UPDATE for Tables with Strings

When the statement UPDATE is used for a column of type STRING or RAWSTRING with the addition SET, it is no longer necessary to specify the primary key in full in the WHERE condition.

Modification 2

SAP Buffering for Single Record Accesses

Access to a table with single record buffering that an equality condition is set for in the WHERE clause for all key fields of the primary key uses SAP buffering, even if the addition SINGLE is not specified for SELECT. Prior to Release 7.0 EhP2, SAP buffering was not used if SINGLE was missing.

Modification 3

Short Strings as Key Fields of Database Tables

From Release 7.0, EhP2, short strings can be used as key fields of the type SSTRING in database tables. This can produce significant memory and performance gains in comparison with using long fields of type CHAR.

Modification 4

Maximum Length of Short Strings in ABAP Dictionary

The maximum length of short strings of type SSTRING has been increased from 255 to 1333.

Modification 5

ABAP Database Connectivity (ADBC)

The class-based framework ABAP Database Connectivity (ADBC), which has existed since Release 6.10 for dynamic access to the Native SQL interface, is now also documented in the ABAP keyword documentation under ADBC.

Modification 6

Streaming and Locators in Open SQL

From Release 7.0, EhP2, Open SQL supports processing of LOBs using data streams and locators.

• A new set of classes and interfaces was introduced.
  
  See Open SQL - Streaming and Locators.
• In reading and changing Open SQL statements, data streams and locators can be linked to LOBs in database tables by using special reference variables.
  
  See SELECT - LOB Handles and INSERT, UPDATE, MODIFY dbtab|view - LOB Handles
• Using the statements TYPES, DATA, and CLASS-DATA, it is possible to derive special LOB handle structures for use in Open SQL.
  
  See TYPES ... FOR ... COLUMNS ...
• The data streams for Open SQL are embedded in a broader streaming framework. Further data streams and filter streams will be added to this in future releases.
  
  See Streaming.
  

Modification 7

Specifying Sorting Columns in Open SQL

The restriction that after ORDER BY in SELECT only columns can be specified that are also specified after SELECT does not apply.

Modification 8

Overflow Handling for sy-dbcnt

If an overflow occurs in the system field sy-dbcnt, meaning the number of statements processed by SQL access is greater than 2,147,483,647, the value of sy-dbcnt is set to -1. The value was previously undefined.