sapdev logo background
sapdev logo sapdev logo
Comments

ABAP TYPES LOB HANDLE COLUMNS Statement syntax, information and example SAP source code



Return to Statement index



TYPES - lob_handle_columns

ABAP Syntax ... { COLUMNS blob1 blob2 ... clob1 clob2 ... }
| { ALL [OTHER] [BLOB|CLOB] COLUMNS } ...

What does it do? These additions determine which columns of the database table or the view dbtab are declared as LOB handle components when deriving a LOB handle structure using the TYPES statement.
COLUMNS blob1 blob2 ... clob1 clob2 ...

specifies individual BLOB s blob1 , blob2 , ... or CLOB s clob1 , clob2 , .... These must exist in dbtab .
ALL OTHER BLOB|CLOB COLUMNS

specifies all dbtab BLOB s or CLOB s which are not included in the specification of individual columns. In the
TYPES statement, at least one individual column, blob or clob , must be specified using COLUMNS ... .
ALL BLOB|CLOB COLUMNS

specifies all dbtab BLOB s or CLOB s .
ALL OTHER COLUMNS

specifies all dbtab LOB s which are not included in the specification of individual columns. In the TYPES statement, at least one individual column must be specified using COLUMNS ... .
ALL COLUMNS

specifies all LOB s of dbtab .
No other type of column specification can follow in the TYPES statement after an ALL OTHER ... column specification.
The combination possibilities of column specifications with one another and with the type specifications
lob_handle_type are explained with the TYPES statement.
Documentation extract taken from SAP system, � Copyright SAP AG. All rights reserved




TYPES_LOB_HANDLE
TYPES_LOB_HANDLE_TYPE




comments powered by Disqus