Example Using FNC_GetLobLength_CL - Advanced SQL Engine - Teradata Database

SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
qwr1571437338192.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1147
lifecycle
previous
Product Category
Teradata Vantage™
BYTE               *value;
int                locatorLength;
FNC_LobLength      lobLength;
FNC_TblOpHandle_t  *Handle;
int                i;               // column index
int                null_ind;
....

// read locator
FNC_TblOpGetAttributeByNdx(Handle, i, (void **) &value, &null_ind, &locatorLength);
if (null_ind != -1)
   // get LOB length
   lobLength = FNC_GetLobLength_CL(value);