-
-
Notifications
You must be signed in to change notification settings - Fork 17
odbc db2 notes
The following links were useful in setting up a DB2 instance for testing:
- https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.5.0/com.ibm.db2.luw.qb.server.doc/doc/c0008711.html
- manual configuration: https://www.ibm.com/support/knowledgecenter/SSEPGG_9.5.0/com.ibm.db2.luw.qb.server.doc/doc/t0007067.html
- create database: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0001941.html
- DB2 uses OS users?: https://www.ibm.com/developerworks/data/library/techarticle/dm-0508wasserman/index.html
- useful commands: https://wiki.base22.com/btg/a-useful-list-of-ibm-db2-commands-81789781.html
- ODBC config:
This page suggests
that DB2 does not support SQLSetDescField, which means that the set-numeric-descriptors method (which sets
the precision, etc) won't work.
In fact, when I check the result of (SQLSetDescField/Int hdesc i SQL_DESC_TYPE SQL_C_NUMERIC), I get -1
(SQL_ERROR), but no diagnostic.
These docs indicate that the current code is using the wrong convention for calling SQLSetDescField
with an integer value, but after fixing that issue the function still returned -1 without diagnostic.
But then these docs seem to contradict that theory.
I also tried changing the numeric/decimal case to use SQL_C_NUMERIC directly rather than SQL_ARD_TYPE,
but it still failed (but with a different message).
Other references:
- https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.apdv.cli.doc/doc/r0000604.html
- https://docs.microsoft.com/en-us/sql/odbc/reference/appendixes/sql-ard-type
- https://docs.microsoft.com/en-us/sql/odbc/reference/appendixes/overriding-default-leading-and-seconds-precision-for-interval-data-types
- https://docs.microsoft.com/en-us/sql/odbc/reference/syntax/sqlsetdescfield-function
- https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.apdv.cli.doc/doc/r0000651.html