May 19, 2012, Saturday, 139


DBMS LOB

From SQL PL Guide for DB2

Jump to: navigation, search

DBMS_LOB module

The module is to work with large objects, like copying, compare, convert, etc. LOBs.

Routines in the DBMS_LOB module:
- APPEND procedure
- CLOSE procedure
- COMPARE function
- CONVERTTOBLOB
- CONVERTTOCLOB
- COPY procedure
- ERASE procedure
- GET_STORAGE_LIMIT function
- GETLENGTH function
- INSTR function
- ISOPEN function
- OPEN procedure
- READ procedure
- SUBSTR function
- TRIM procedure
- WRITE procedure
- WRITEAPPEND procedure


Link to the DB2 Information Center: DB2 9.7