DB2 Scalar functions - 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

NCLOB

The NCLOB function returns a NCLOB representation of any type of national character string.

NCLOB(national-character-expression ,integer )

The schema is SYSIBM.

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

The NCLOB scalar function is a synonym for a scalar cast function with result string units as specified in the following table.

Table 1. NCLOB scalar function synonyms

NCLOB_MAPPING value Synonym function Result string units
CHAR_CU32 CLOB CODEUNITS32
GRAPHIC_CU32 DCLOB CODEUNITS32
GRAPHIC_CU16 DCLOB1 CODEUNITS16
  1. When the first argument has string units CODEUNITS32 and the second argument is not specified, the length attribute of the result is different from the DCLOB function because the string units of the result is CODEUNITS16.
    In this case, the length attribute of the result is 2 times the length attribute of the result that is otherwise determined by the DCLOB function.

© Copyright IBM Corp.