FNC_TblOpGetLocalOrderByDef Function | C Library Functions | Teradata Vantage - FNC_TblOpGetLocalOrderByDef - 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™

Purpose

Retrieves the LOCAL ORDER BY clause information of the input stream for a table operator.

Syntax

void
FNC_TblOpGetLocalOrderByDef(int              streamno,
                            FNC_Names_Ord_t  *out_colname);
int streamno
an input stream number.
FNC_Names_Ord_t *out_colname
a pointer to the location where the column names and their ordering will be stored.

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

Usage Notes

Before calling FNC_TblOpGetLocalOrderByDef, you must allocate memory for the out_colname buffer:

FNC_Names_Ord_t *out_colname = FNC_malloc( TblOpSIZEORDERBY(
                                   FNC_TblOpCountHashByDef(streamno)) );

You must release the allocated memory when out_colname is no longer needed. If FNC_malloc was used to allocate the memory, use FNC_free to release it.