AS ABAP Release 758, ©Copyright 2024 SAP SE. All rights reserved.
ABAP - Keyword Documentation → ABAP - ABAP Release News → News for ABAP Release 7.0 and its EhPs → News for ABAP Release 7.0, EhP2 →
Mail Feedback
Database Access in ABAP Release 7.0, EhP2
1. UPDATE for Tables with Strings
2. Table Buffering with Single Record Access
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 ABAP SQL
7. Specifying Sorting Columns in ABAP SQL
8. Overflow Handling for sy-dbcnt
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.
Table Buffering with Single Record Access
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
table buffering, even
if the addition SINGLE is
not specified for SELECT. Before ABAP release 7.0 EhP2, table buffering was bypassed if SINGLE was missing.
Short Strings as Key Fields of Database Tables
From ABAP 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.
Maximum Length of Short Strings in ABAP Dictionary
The maximum length of short strings of type SSTRING has been increased from 255 to 1333.
ABAP Database Connectivity (ADBC)
The class-based framework ABAP Database Connectivity (ADBC), which has existed since ABAP release 6.10 for dynamic access to the
Native SQL interface, is now also documented in the ABAP keyword documentation under
ADBC.
Streaming and Locators in ABAP SQL
From ABAP release 7.0, EhP2, ABAP SQL supports processing of LOBs using data streams and locators.
- A new set of classes and interfaces was introduced.
- In reading and changing ABAP 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 ABAP SQL.
- The data streams for ABAP SQL are embedded in a broader streaming framework. Further data streams and filter streams will be added to this in future releases.
See Streaming.
Specifying Sorting Columns in ABAP SQL
The restriction that after ORDER BY in SELECT only columns can be specified that are also specified after SELECT does not apply.
This also applies to the addition PRIMARY KEY. Previously, all columns of
the primary key had to be in the SELECT list, but this is no longer the case.
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.