Skip to content

ABAP Keyword Documentation →  ABAP - Reference →  Declarative statemnts →  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 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 BLOBs blob1, blob2, ... or CLOBs clob1, clob2, .... These must exist in dbtab.
  • ALL OTHER BLOB|CLOB COLUMNS

    specifies all dbtab BLOBs or CLOBs 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 BLOBs or CLOBs.
  • ALL OTHER COLUMNS

    specifies all dbtab LOBs 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 LOBs 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.