Syntax - 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™
void
FNC_GetArrayElementCount ( ARRAY_HANDLE  aryHandle,
                           int           *presentElts,
                           int            lastPresentElement[])
ARRAY_HANDLE aryHandle
the handle to an ARRAY type that is defined to be an input parameter to an external routine.
int *presentElts
the number of elements in the ARRAY argument that are set to a value, including NULL. An element that is a structured UDT counts as one attribute.
int lastPresentElement[]
the information for the last present element of the ARRAY value. For a 1-D ARRAY, the index to the last present element is provided as lastPresentElement[0]. If the ARRAY type is n-D, then the complete dimension information for this index is placed in cells lastPresentElement[1], lastPresentElement[2], lastPresentElement[3] ... lastPresentElement[FNC_ARRAYMAXDIMENSIONS] as needed.