CLOB

Returns a character-string representation of the first argument. Valid types are:

Character string if the first argument is any type of character string

Graphic string if the first argument is an UCS-2 graphic string

Integer number if the first argument is a SMALLINT, INTEGER, or BIGINT

Decimal number if the first argument is a packed or zoned decimal number

Double-precision floating-point number if the first argument is a DOUBLE or REAL

Example:

The following function returns a CLOB for the string 'This is a CLOB'.

  SELECT CLOB('This is a CLOB') FROM T1