Teradata Database Array data type values appearing in result sets and used as statement parameters are of ODBC SQL Variable Character type (SQL_VARCHAR or SQL_WVARCHAR). The format of an array as ODBC SQL Variable Character is the transformed format as described in SQL Data Types and Literals (B035-1143).
Briefly, the format is a string of each array element value separated by comma and enclosed in parenthesis as shown as below, assuming the array has N elements:
where each element is transformed depending on its type.
Arrays are visible through the ODBC Catalog functions as shown in the following table.
|SQLTables||TABLE_TYPE column: "TYPE".
TABLE_NAME column: Contains type name, i.e. the name of the ARRAY type from the CREATE TYPE.
|SQLColumns||DATA_TYPE column: SQL_UNKNOWN_TYPE (zero)
TYPE_NAME column: Type name.
|SQLProcedureColumns||As for SQLColumns|