16.20 - Array Data Types - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

ODBC Driver for Teradata
August 2020
User Guide

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.

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