The column names returned by the ODBC function SQLGetTypeInfo do not adhere
to the standard.
The column EXPRESSION1 should be named DATA_TYPE and the column MONEY should
(probably) be named FIXED_PREC_SCALE.
Obviously this can be corrected through modification of a SQL statement in
the file sys\src\pa\vpa11ac, line 157:
/* ODBC 3.x has different column names */
UCHAR *PA11SELECTCOLTYPES_ODBC35 = { (UCHAR*) \
"SELECT TYPE_NAME, decode (DATA_TYPE, \
%d, %d, %d, %d, %d, %d, \
DATA_TYPE), PRECISION AS COLUMN_SIZE, LITERAL_PREFIX, \
LITERAL_SUFFIX, \
CREATE_PARAMS, NULLABLE, CASE_SENSITIVE, SEARCHABLE, UNSIGNED_ATTRIBUTE, \
MONEY, AUTO_INCREMENT AS AUTO_UNIQUE_VALUE, LOCAL_TYPE_NAME, \
MINIMUM_SCALE, \
MAXIMUM_SCALE, SQL_DATA_TYPE, SQL_DATETIME_SUB, NUM_PREC_RADIX, \
INTERVAL_PRECISION \
FROM "SYSDBA".SYSODBCTYPES "};
should be replaced with:
/* ODBC 3.x has different column names */
UCHAR *PA11SELECTCOLTYPES_ODBC35 = { (UCHAR*) \
"SELECT TYPE_NAME, decode (DATA_TYPE, \
%d, %d, %d, %d, %d, %d, \
DATA_TYPE) AS DATA_TYPE, PRECISION AS COLUMN_SIZE, LITERAL_PREFIX, \
LITERAL_SUFFIX, \
CREATE_PARAMS, NULLABLE, CASE_SENSITIVE, SEARCHABLE, UNSIGNED_ATTRIBUTE, \
MONEY AS FIXED_PREC_SCALE, AUTO_INCREMENT AS AUTO_UNIQUE_VALUE,
LOCAL_TYPE_NAME, \
MINIMUM_SCALE, \
MAXIMUM_SCALE, SQL_DATA_TYPE, SQL_DATETIME_SUB, NUM_PREC_RADIX, \
INTERVAL_PRECISION \
FROM "SYSDBA".SYSODBCTYPES "};
Regards
Detlef Hoeffner
Dipl. Wirtsch.-Ing. Detlef H�ffner
Tel. +49 (0) 177 3958509
e-mail: [EMAIL PROTECTED]
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
