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 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 theTYPES 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.
