Skip to content

ABAP Keyword Documentation →  ABAP − Reference →  Declarations →  Declaration Statements →  Data Types and Data Objects →  Declaring Data Types →  TYPES →  TYPES - LOB HANDLE 

TYPES - lob_handle_columns

Other versions: 7.31 | 7.40 | 7.54

Syntax


  ... { COLUMNS blob1 blob2 ... clob1 clob2 ... } 

    | { ALL [OTHER] [BLOB|CLOB] COLUMNS } ...

Effect

These additions define which columns of the database table or the view dbtab are declared as LOB handle components when deriving a LOB handle structure using the statement TYPES.

  • COLUMNS blob1 blob2 ... clob1 clob2 ...

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

    This specifies all BLOBs or CLOBs in dbtab that are not covered when individual columns are specified. In the statement TYPES, at least one individual column blob or clob must be specified using COLUMNS ...
  • ALL BLOB|CLOB COLUMNS

    specifies all BLOBs or CLOBs of dbtab.
  • ALL OTHER COLUMNS

    This specifies all LOBs in dbtab that are not covered when individual columns are specified. In the statement TYPES, at least one individual column must be specified using COLUMNS ...
  • ALL COLUMNS

    This specifies all LOBs in dbtab.

No other columns can be specified in the statement TYPES after columns specified using ALL OTHER ...

The different ways in which columns can be combined with each other and with the types specified using lob_handle_type are explained in the statement TYPES.


Note

Columns of the data type GEOM_EWKB are not supported as BLOBs.


Example

Demonstration of various specified columns in the definition of LOB-Handle components.

TYPES lob_handle TYPE demo_lob_table 
                 READER FOR COLUMNS clob1 clob2 
                 LOB HANDLE FOR ALL BLOB COLUMNS 
                 LOCATOR FOR ALL OTHER CLOB COLUMNS.

Executable Example

Deriving LOB Handle Structures