17.10 - Syntax - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1147-171K
Language
English (United States)
void
FNC_GetArrayElementCount ( ARRAY_HANDLE  aryHandle,
                           int           *presentElts,
                           int            lastPresentElement[])

Syntax Elements

aryHandle
the handle to an ARRAY type that is defined to be an input parameter to an external routine.
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.
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.