MCPSQL supports internal BLOBs and CLOBs. BLOB data is transmitted as is but CLOB data is translated between ASCII and EBCDIC if accessed through Query Design Center or JDBC. CLOB data accessed through the SQL CLI is not translated.

LOB data is transparent to MCPSQL except for translation. LOBs can only be stored, accessed, and deleted. They cannot be searched, ordered, or compared. However, EXISTS and NULL predicates are valid. None of the SQL functions are valid with LOBs (for example, SUBSTRING, TRIM, concatenation, and so on.).

LOBs are not supported by Module Language or DMQUERY.