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 declaring a LOB handle structure using the TYPES statement.

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

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

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

    specifies all dbtab BLOBs or CLOBs.
  • ALL OTHER COLUMNS

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

    specifies all LOBs of dbtab.

No other type of column specification can follow 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.