Inline Method Restriction - Teradata Preprocessor2

Teradata® Preprocessor2 for Embedded SQL Programmer Guide

Product
Teradata Preprocessor2
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-19
dita:mapPath
whb1544831946911.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2446
lifecycle
previous
Product Category
Teradata Tools and Utilities
  • 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 below (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)