Syntax - 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™
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.