EMPTY_BLOB, EMPTY_CLOB, EMPTY_DBCLOB, and EMPTY_NCLOB scalar functions

These functions return a zero-length value with a data type of BLOB, CLOB, or DBCLOB.

Read syntax diagramSkip visual syntax diagram EMPTY_BLOBEMPTY_CLOBEMPTY_DBCLOBEMPTY_NCLOB ()

The schema is SYSIBM.

The empty value functions return a zero-length value of the associated data type. There are no arguments to these functions (the empty parentheses must be specified).

  • The EMPTY_BLOB function returns a zero-length value with a data type of BLOB(1).
  • The EMPTY_CLOB function returns a zero-length value with a data type of CLOB(1).
  • The EMPTY_DBCLOB and EMPTY_NCLOB functions return a zero-length value with a data type of DBCLOB(1).

The result of these functions can be used in assignments to provide zero-length values where needed.

The EMPTY_NCLOB function can be specified only in a Unicode database (SQLSTATE 560AA).