SAP NEWS-71-SQL



Get Example source ABAP code based on a different SAP table
  



Database Access in ABAP Release 7.0, EhP2
ITOC

ABAP_MODIFICATION_NN 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.

ABAP_MODIFICATION_NN 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.

ABAP_MODIFICATION_NN 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.

ABAP_MODIFICATION_NN 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_MODIFICATION_NN 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.

ABAP_MODIFICATION_NN Streaming and Locators in AB_SQL

From ABAP_RELEASE 7.0, EhP2, AB_SQL supports processing of LOBs using data streams and locators.
A new set of classes and interfaces was introduced. See AB_SQL - Streaming and Locators
In reading and changing AB-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 AB_SQL . See TYPES ... FOR ... COLUMNS ...
The data streams for AB_SQL are embedded in a broader streaming framework. Further data streams and filter streams will be added to this in future releases. See Streaming.

ABAP_MODIFICATION_NN Specifying Sorting Columns in AB_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.

ABAP_MODIFICATION_NN 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.