SQL Reference

CLOB

>>-CLOB--(--character-string-expression----+--------------+--)--><
                                           '-,--integer---'
 

The schema is SYSIBM.

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

character-string-expression

An expression that returns a value that is a character string.

integer

An integer value specifying the length attribute of the resulting CLOB data type. The value must be between 0 and 2 147 483 647. If 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. If the argument can be null, the result can be null; if the argument is null, the result is the null value.