Consultor Eletrônico



Kbase P126126: SQL-92: How does the ODBC API SQLcolumns function describe an array column?
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   10/3/2007
Status: Unverified

GOAL:

SQL-92: How does the ODBC API SQLcolumns function describe an array column?

GOAL:

Does the Progress OpenEdge SQL-92 support ODBC API calls to query array column attributes?

FACT(s) (Environment):

All Supported Operating Systems
OpenEdge 10.x

FIX:

The ODBC API SQLcolumns function will describe an OpenEdge array column as a VARCHAR. As of now, the OpenEdge SQL-92 and its ODBC drivers do not support any API calls which will return information on the attributes of an array column, such as array element data types and array dimension. Instead an ODBC application will see an array column as a character data type.