FNC_SetNullBitVectorByElemIndex Syntax - Teradata Vantage - Analytics Database

SQL External Routine Programming

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-03-30
dita:mapPath
iiv1628111441820.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
qnu1472247494689
lifecycle
latest
Product Category
Teradata Vantage™
void
FNC_SetNullBitVectorByElemIndex ( NullBitVecType *NullBitVector,
                                  int             indexValue[],
                                  int             presenceValue,
                                  long            bufSize,
                                  bounds_t       *arrayScope,
                                  int             numDimensions)

Syntax Elements

NullBitVector
a NullBitVector array previously allocated by the caller.
The data type used to access the NullBitVector is defined in sqltypes_td.h as:
typedef unsigned char NullBitVecType;
indexValue[]
the index to the ARRAY element whose corresponding presence bit in the NullBitVector is to be set. For a 1-D ARRAY, the index to the last present element is provided as indexValue[0]. If the ARRAY type is n-D, then the complete dimension information for this index is placed in cells indexValue[1], indexValue[2], indexValue[3] ... indexValue[FNC_ARRAYMAXDIMENSIONS] as needed, where FNC_ARRAYMAXDIMENSIONS specifies the maximum number of dimensions in an ARRAY type as defined in sqltypes_td.h:
#define FNC_ARRAYMAXDIMENSIONS 5
presenceValue
the value to assign to the presence bit (indicated by indexValue). The valid values are 1 or 0.
bufSize
the size in bytes of the NullBitVector as allocated by the caller prior to initialization of the NullBitVector by setting all bytes to 0.
arrayScope
an array of bounds_t structures that provides the scope information for the ARRAY which the NullBitVector describes. You can call FNC_GetArrayTypeInfo to get this information. See FNC_GetArrayTypeInfo [Deprecated].
numDimensions
the number of dimensions defined for the ARRAY which the NullBitVector describes. You can call FNC_GetArrayTypeInfo to get this information. See FNC_GetArrayTypeInfo [Deprecated].