TO_CLOB scalar function The TO_CLOB function returns a CLOB representation of a character string type. TO_CLOB(character-string-expression ,integer ) The schema is SYSIBM. The TO_CLOB scalar function is a synonym for the CLOB scalar function.