External Representation
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. |
Restrictions
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
The following are some functions and operators that support BLOB types:
- BYTES
- Concatenation operator (||)
- SUBSTRING/SUBSTR
- TYPE
- Explicit data type conversion (CAST and Teradata conversion syntax)
- User-defined functions (UDFs)
- Stored procedures
- External stored procedures