16.20 - Syntax - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Advanced SQL Engine
Teradata Database
Release Number
Release Date
April 2020
Content Type
Programming Reference
Publication ID
English (United States)
FNC_TblOpGetAttributeByNdx(FNC_TblOpHandle_t  *handle,
                           int                 index,
                           void              **valueptr,
                           int                *null_ind,
                           int                *length);
FNC_TblOpHandle_t *handle
the handle to the current read context.
For details about the FNC_TblOpHandle_t structure, see Table Operator Interface Functions.
int index
the index of an attribute. The range of values is from 0 to i-1, where 0 is the index of the first attribute.
void **valueptr
location of pointer to the attribute value to be returned.
int *null_ind
whether the attribute is null. -1 indicates null and 0 indicates not null.
int *length
the size in bytes of the value pointed to by *valueptr. For character varying data types, the length includes the 2 byte length field.