CLOB scalar function

The CLOB function returns a CLOB representation of a character string type.

Read syntax diagramSkip visual syntax diagramCLOB(character-string-expression ,integer)

The schema is SYSIBM.

In a Unicode database, if a supplied argument is a graphic string, it is first converted to a character string data type before the function is executed.

character-string-expression
An expression that returns a value that is a character string. The expression cannot be a character string defined as FOR BIT DATA (SQLSTATE 42846).
integer
An integer value specifying the length attribute of the resulting CLOB data type. If the character-string-expression string unit is OCTETS, the value must be between 0 and 2 147 483 647. If the character-string-expression string unit is CODEUNITS32, the value must be between 0 and 536 870 911. If a value for integer is not specified, the length of the result is the same as the length of the first argument.

The result of the function is a CLOB in the string units of character-string-expression. If the argument can be null, the result can be null; if the argument is null, the result is the null value.