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

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.