Array Data Types - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
17.10
Published
October 2021
Language
English (United States)
Last Update
2021-11-02
dita:mapPath
wxs1608578396899.ditamap
dita:ditavalPath
nkw1500504256726.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

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 Teradata Vantage™ - 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