Array Data Types - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-25
dita:mapPath
fxv1527114222338.ditamap
dita:ditavalPath
Audience_PDF_product_legacy_odbc_include.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

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