Retrieves all the values associated with a given key in a Custom clause and their corresponding lengths.
int FNC_TblOpGetCustomValuesOf(Key_info_t *key);
- Key_info_t *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.
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.
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:
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.
Example Using FNC_TblOpGetCustomValuesOf
See C Table Operator for an example of how to use this function.