TYPES - LOB HANDLE
TYPES dtype TYPE dbtab|view
lob_handle_type FOR lob_handle_columns
[ lob_handle_type FOR lob_handle_columns
Derives an LOB handle structure as a work area for working with
streaming and locators in Open SQL.
dbtab expects a
database table defined in ABAP Dictionary or a
database view defined for
view in ABAP Dictionary.
lob_handle_columns, when specified, are used to determine
The statement creates a deep structure which is constructed exactly the same for all columns not included
in the specified columns as it is for a regular
TYPE reference to
dbtab. For the LOBs included in the specified columns, a component with the same name is created as a
LOB handle component. The
static type of the LOB
handle components is a class or an interface which is determined by the specified type
lob_handle_type, and is assigned to the respective specified column.
- The definition of the LOB handle components must not contain contradictions, which means that columns must not be assigned to unsuitable types or a column cannot be assigned to multiple types.
The definition of LOB handle components must not contain redundancies. Each specified
... lob_handle_type FOR lob_handle_columns ...
must create a set of LOB handle components that do not overlap with another specified set of LOB handle components.
The definition of the LOB handle components must be specified with as few components as possible. If
the same set of LOB handle components can be specified once rather than using multiple input, the more comprehensive option must be used.
- At least one column must be specified.
- The types specified for the first three specified column for LOB handle components for reads and the first two columns for LOB handle components for writes cannot be the same.
In each case there can only be one column specified
ALL ... COLUMNS, in which
The specified columns
ALL BLOB|CLOB COLUMNSinclude all BLOBs or CLOBs. If they are specified, an individual BLOB or CLOB cannot also be specified in a specified column
COLUMNS ...for the same static type.
The specified columns ALL
OTHER COLUMNS include all columns that are not specified individually.
ALL OTHER BLOB COLUMNSor
ALL OTHER CLOB COLUMNScannot be specified at the same time.
specified columnsALL COLUMNS include all LOBs and can therefore only be specified on their own.
LOB handle structures can also be defined using the corresponding typing of components between
- LOB handle structures can also be derived in ABAP Dictionary. The display of database tables or views containing LOBs includes a function for this.
dbtabdoes not contain any LOBs that match the specified columns, no LOB handle components are created and the statement creates a normal work area.
If LOBs are added to
dbtabthat match the specified columns
ALL [OTHER] ..., LOB handle components are also created for these.