- Data rows processed by Teradata PP2 can contain both non-LOB and LOB data. Although BLOB and CLOB columns are treated the same as VARBYTE and VARCHAR columns, BLOB and CLOB columns must have an 8-byte integer length indicator instead of the 2-byte length indicator used for the VARBYTE and VARCHAR columns.
- PP2 provides this LOB support in Descriptor mode (using SQLDA) only.
- When USINGLOBDATA is ON, PP2 considers an extended SQLDA structure as described here (a new element sqllenx is added to support LOB data):
struct sqlda { unsigned char sqldaid[8]; int sqldabc; short sqln; short sqld; struct sqlvar { short sqltype; unsigned short sqllen; unsigned char *sqldata; short *sqlind; truct sqlname { short length; unsigned char data[30]; } sqlname; int sqllenx; } sqlvar[1]; };For all non-LOB data types, sqllen will hold the data length, and for all LOB data, sqllenx will hold the data length. When the USINGLOBDATA is off, PP2 considers the old SQLDA structure only (without sqllenx element)