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:
(<element1>,<element2>,...<elementN>)
where each element is transformed depending on its type.
Arrays are visible through the ODBC Catalog functions as shown in the following table.
| Catalog function | Description |
|---|---|
| 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 |