The DataBlade API does not provide direct support for simple large objects. Therefore, it cannot directly access TEXT and BYTE columns. However, the database server provides the following cast functions between simple and smart large objects.
| Type Conversion | SQL Cast Function |
|---|---|
| From the TEXT data type to the CLOB data type | TextToClob( ) |
| From the BYTE data type to the BLOB data type | ByteToBlob( ) |
For more information on these SQL cast functions, see the description of the Expression segment in the IBM Informix: Guide to SQL Syntax.
C UDRs can accept TEXT data as arguments because the database server passes all character data in the mi_lvarchar data type. For more information, see Character Data in C UDRs (Server).
C UDRs can also accept BYTE data as long as they declare and handle this data as a smart large object. The database server converts the BYTE data to BLOB data when it passes this data to the UDR.