TO_NCLOB scalar function The TO_NCLOB function returns any type of national character string. TO_NCLOB(character-string-expression) The schema is SYSIBM. The TO_NCLOB scalar function is a synonym for the NCLOB scalar function. The TO_NCLOB function can be specified only in a Unicode database (SQLSTATE 560AA).