Returns a DBCLOB representation of a string expression.
The first argument must be a string expression (not BLOB or CHAR or VARCHAR bit data). The second argument is the length attribute of the result. This can be a specified integer constant between 1 and 7 864 320. If second argument is not specified or is DEFAULT, the length attribute of the result is the same as the length attribute of the first argument. If the first argument is an empty string constant, the length attribute of the result if 1. The third argument is the CCSID of the result. It must be a DBCS or UCS-2 CCSID. It cannot be 65535.
Example:
Using the EMPLOYEE table, return the DBCLOB equivalent of the first name (FIRSTNME) for employee number (EMPNO) '000050'.
SELECT DBCLOB(FIRSTNME) FROM EMPLOYEE WHERE EMPNO = '000050'