DB2 Scalar functions - EMPTY_BLOB, EMPTY_CLOB, EMPTY_DBCLOB, and EMPTY_NCLOB


Volta a página anterior

Volta ao Menu das scalar functions

Volta ao Menu Principal


Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

EMPTY_BLOB, EMPTY_CLOB, EMPTY_DBCLOB, and EMPTY_NCLOB

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

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


© Copyright IBM Corp.