Ansicht
Dokumentation
ABENOPEN_SQL_STREAMING - OPEN SQL STREAMING
rdisp/max_wprun_time - Maximum work process run time ABAP Short ReferenceThis documentation is copyright by SAP AG.
- Streaming
supports streaming for LOBs in data sources.
System Classes and System Interfaces for Reader and Writer Streams
The system classes for the various types of data streams are:
- CL_ABAP_DB_C_READER for character-like reader streams. The streaming data source is a CLOB.
- CL_ABAP_DB_X_READER for binary reader streams. The streaming data source a BLOB.
- CL_ABAP_DB_C_WRITER for character-like writer streams. The streaming data sink is a CLOB.
- CL_ABAP_DB_X_WRITER for binary writer streams. The streaming data sink a BLOB.
The special interfaces
are used to access the reader and writer streams independently of the stream type. For further resource-independent classes and interfaces, as well as for the hierarchy of the object types, see the figure and explanation under Streaming.
Important Methods
The methods for streaming in are the same as for general streaming.
Data Sources and Data Sinks
Any LOBs declared in DDIC database tables can be considered as data sources or data sinks. The instances of the classes above are data streams joined to LOBs. These are LOB handles and implement the corresponding interfaces. Their use in involves reference variables that point to the relevant LOB handles.
Creating Data Streams for LOBs
Reader Streams
A reader stream that is bound to an LOB (that is, an instance of the class CL_ABAP_DB_C_READER or CL_ABAP_DB_X_READER) can only be created if, in the INTO clause of the statement SELECT, a LOB from the result set is assigned to a reference variable for a reader stream.
Refer to SELECT - LOB Handles.
Writer Streams
A writer stream that is bound to an LOB (that is, an instance of the class CL_ABAP_DB_C_WRITER or CL_ABAP_DB_X_WRITER) can only be created if a reference variable for a reader stream is specified as a source in the statements INSERT, UPDATE, or MODIFY. It is not possible to specify more general reference variables.
See INSERT, UPDATE, MODIFY dbtab - LOB Handles.
Closing Data Streams for LOBs
Since the number of data streams open at one time is limited to 16, they should be closed as soon as possible using the CLOSE method. Regardless of this, reader streams are closed implicitly at the end of a SELECT loop and at the end of a database LUW. An open writer stream can be closed implicitly only by using a database rollback. Database commits for open writer streams, on the other hand, produce the runtime error COMMIT_STREAM_ERROR.
Examples
BAL Application Log Documentation CPI1466 during Backup
This documentation is copyright by SAP AG.
Length: 6156 Date: 20240425 Time: 071234 sap01-206 ( 92 ms )