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.
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 |