void FNC_GetAnyTypeParamInfo(int bufsize, int *numAnyTypeParams, anytype_param_info_t *AnyTypeAttributeArray);
- AnyTypeAttributeArray
- Defined in sqltypes_td.h as:
typedef struct anytype_param_info_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; [ CHARACTER UDTName[FNC_MAXNAMELEN]; ] SMALLINT udt_indicator; } anytype_param_info_t;
Syntax Elements
- bufsize
- Size of the AnyTypeAttributeArray buffer.
- numAnyTypeParams
- Number of input and output arguments of TD_ANYTYPE data type.
- AnyTypeAttributeArray
- Pointer to the buffer that will hold the information about the TD_ANYTYPE parameters.
- 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