Array Data Types

ODBC Driver for Teradata® User Guide

prodname
ODBC Driver for Teradata
vrm_release
16.20
category
User Guide
featnum
B035-2526-108K

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