CLOB scalar function The CLOB function returns a CLOB representation of a character string. CLOB(,integer) 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.