Syntax - Analytics Database - Teradata Vantage

SQL External Routine Programming

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
iiv1628111441820.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1147
lifecycle
latest
Product Category
Teradata Vantage™
void
FNC_GetAnyTypeParamInfo_eon(int                 bufsize,
                            int                *numAnyTypeParams,
                     anytype_param_info_eon_t  *AnyTypeAttributeArray);
AnyTypeAttributeArray
Defined in sqltypes_td.h as:
typedef struct anytype_param_info_eon_t {
   INTEGER_td       paramIndex;
   dtype_et         datatype;
   dmode_et         direction;
   INTEGER_td       max_length;
   FNC_LobLength_t  lob_length;
   SMALLINT         total_interval_digits;
   SMALLINT         num_fractional_digits;
   charset_et       charset;
   Unicode_Text     UDTName[FNC_MAXNAMELEN_EON];
   SMALLINT         udt_indicator;
} anytype_param_info_eon_t;

Syntax Elements

bufsize
Size of the AnyTypeAttributeArray buffer.
numAnyTypeParams
Number of input and output arguments that is of TD_ANYTYPE data type.
AnyTypeAttributeArray
Pointer to the buffer that will hold the information about the TD_ANYTYPE parameters.
AnyTypeAttributeArray
Pointer to the buffer that will hold the information about the TD_ANYTYPE parameters.
For more information about dtype_et, total_interval_digits, num_fractional_digits, or charset_et, see FNC_GetStructuredAttributeInfo [Deprecated].
For more information about dmode_et , see FNC_CallSP.
paramIndex
the parameter positional index starting from 1. For the return parameter, the index will be -1.
datatype
the data type of the parameter.
direction
indicates whether the parameter is an input, output, or an INOUT parameter.
max_length
the maximum length in bytes that this parameter may utilize. If the parameter is a LOB type, max_length indicates the LOB_REF length. lob_length provides the length of the LOB data itself.
lob_length
the maximum length of the parameter if it is a LOB type parameter.
total_interval_digits
the precision value for certain data types. For example, the value n in a DECIMAL(n,m) type or in INTERVAL DAY(n) TO SECOND(m). The list of types that use this value is the same as that of attribute_info_t.total_interval_digits.
num_fractional_digits
the precision or scale value for certain data types. For example, the value m in a DECIMAL(n,m) type or in INTERVAL DAY(n) TO SECOND(m). The list of types that use this value is the same as that of attribute_info_t.num_fractional_digits.
charset
the server character set associated with a character data type.
UDTName
[Required if parameter is a UDT, disallowed otherwise]. The name of the UDT.
udt_indicator
Indicates kind of UDT:
udt_indicator UDT Kind
0 Not a UDT
1 Structured UDT
2 Distinct UDT

For distinct types, the data type returns the underlying type of the distinct type UDT.

3 Internal UDT
4 Array Type