FNC_TblOpGetCustomValuesOf Function | C Library Functions | Teradata Vantage - FNC_TblOpGetCustomValuesOf - Advanced SQL Engine - Teradata Database

SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
rin1593638965306.ditamap
dita:ditavalPath
rin1593638965306.ditaval
dita:id
B035-1147
lifecycle
previous
Product Category
Teradata Vantageā„¢

Retrieves all the values associated with a given key in a Custom clause and their corresponding lengths.

The values associated with a given key in a Custom clause and the length of each value.

The value that is returned can be an OID (object identifier). The OID is in the form of a client locator.

Syntax

int
FNC_TblOpGetCustomValuesOf(Key_info_t *key);

Syntax Elements

key
the location of the data structure where key is specified and where values and lengths will be placed.

For details about the Key_info_t structure, see Table Operator Data Structures.

Usage Notes

Before calling FNC_TblOpGetCustomValuesOf, you must allocate memory for the values to be returned:

key->values_r = FNC_malloc(sizeof(values_t)*key->numOfVal);

You must release the memory when the values are no longer needed:

FNC_free(key->values_r);

Example Using FNC_TblOpGetCustomValuesOf

See C Table Operator for an example of how to use this function.

Related Information

For details about the Custom clause of a table operator, see information about the SELECT statement FROM clause in Teradata Vantageā„¢ - SQL Data Manipulation Language, B035-1146.