The following table lists the client representations for the Teradata SQL BLOB data type.
Define the length of the BLOB string as k, where 0 ≤ k ≤ n.
|Client CPU Architecture||Client Internal Data Format|
|IBM mainframe||Eight bytes (16-bit SMALLINT) length count k followed by k bytes of BYTE data.|
||Eight bytes (16-bit SMALLINT) length count k followed by k bytes of BYTE data.|
A table can have a maximum of 32 LOB columns.
A LOB column cannot be a component of an index. Because of this restriction, a table must define at least one non-LOB column.
Queue tables cannot have BLOB columns.
Functions That Operate on BLOBs
- Concatenation operator (||)
- Explicit data type conversion (CAST and Teradata conversion syntax)
- User-defined functions (UDFs)
- Stored procedures
- External stored procedures