17.20 - Array Data Types - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2022-06-21
dita:mapPath
uqj1639470627591.ditamap
dita:ditavalPath
nkw1500504256726.ditaval

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