SQLBindParameter Windows, UNIX
No restrictions.
Note:
If more than one LONG column is to be processed using the statement INSERT, UPDATE or DELETE and the parameters are to be linked with SQL_DATA_AT_EXECUTE, it must be taken into account that the NULL value is only possible for one LONG column with SQLPutData. If more LONG columns are to be set to the NULL value in one statement, the columns must be linked with SQL_NULL_DATA in pcbValue. If this restriction is violated, the ODBC driver returns szSqlState = S1000 SQLCODE =-22002.
SQLColumns Windows, UNIX
No restrictions.
SQLDriverConnect Windows
No restrictions.
Note:
The parameter hwnd is ignored.
SQLGetConnectOption Windows, UNIX
The following list shows all return codes and supported options of the ADABAS ODBC driver:
SQL_ACCESS_MODE pvParam = SQL_MODE_READ_WRITE
SQL_AUTOCOMMIT pvParam = SQL_AUTOCOMMIT_ON
SQL_LOGIN_TIMEOUT pvParam = 15 This parameter is ignored.
SQL_OPT_TRACE pvParam = SQL_OPT_TRACE_OFF =0
SQL_OPT_TRACEFILE The filename set with SQLSetConnectOption.
Default: "\sql.log"
SQL_TRANSLATE_DLL not used
SQL_TRANSLATE_OPTION pvParam=0
SQL_TXN_ISOLATION pvParam=SQL_TXN_READ_COMMITTED
SQL_MODE = SQL_CONNECT_OPT_DRVR_START + 2
pvParam = (1 = ADABAS, 2 = DB2, 3 = ANSI,
4 = ORACLE )
SQLGetData Windows, UNIX
No restrictions.
Note:
For LONG columns that are truncated (szSqlState S1004), SQLGetData returns SQL_NO_TOTAL in pcbValue for an undeterminable length. As this presents difficulties to some applications (MS ACCESS when opening an OLE object), it is possible to adapt pcbValue to the actual requirements. LONG_MAX, cbValueMax, cbValueMax+1 or any value 0 < n > LONG_MAX can be returned in pcbValue. Therefore LongVarTrunc must be set in the data source section. The following values are possible:
LONG_MAX = -1
VALUE_MAX = -2
VALUE_MAXPLUSONE = -3
NO-TOTAL = -4
or > 0 for a fixed value
SQLGetFunctions Windows, UNIX
When passing fFunction=SQL_API_ALL_FUNCTIONS, the elements of the array are initialized with the following values:
SQL_API_SQLALLOCCONNECT, TRUE
SQL_API_SQLALLOCENV, TRUE
SQL_API_SQLALLOCSTMT, TRUE
SQL_API_SQLBINDCOL, TRUE
SQL_API_SQLCANCEL, TRUE
SQL_API_SQLCOLATTRIBUTES, TRUE
SQL_API_SQLCONNECT, TRUE
SQL_API_SQLDESCRIBECOL, TRUE
SQL_API_SQLDISCONNECT, TRUE
SQL_API_SQLERROR, TRUE
SQL_API_SQLEXECDIRECT, TRUE
SQL_API_SQLEXECUTE, TRUE
SQL_API_SQLFETCH, TRUE
SQL_API_SQLFREECONNECT, TRUE
SQL_API_SQLFREEENV, TRUE
SQL_API_SQLFREESTMT, TRUE
SQL_API_SQLGETCURSORNAME, TRUE
SQL_API_SQLNUMRESULTCOLS, TRUE
SQL_API_SQLPREPARE, TRUE
SQL_API_SQLROWCOUNT, TRUE
SQL_API_SQLSETCURSORNAME, TRUE
SQL_API_SQLSETPARAM, TRUE
SQL_API_SQLTRANSACT, TRUE
SQL_API_SQLCOLUMNS, TRUE
SQL_API_SQLDRIVERCONNECT, TRUE
SQL_API_SQLGETCONNECTOPTION, TRUE
SQL_API_SQLGETDATA, TRUE
SQL_API_SQLGETFUNCTIONS, TRUE
SQL_API_SQLGETINFO, TRUE
SQL_API_SQLGETSTMTOPTION, TRUE
SQL_API_SQLGETTYPEINFO, TRUE
SQL_API_SQLPARAMDATA, TRUE
SQL_API_SQLPUTDATA, TRUE
SQL_API_SQLSETCONNECTOPTION, TRUE
SQL_API_SQLSETSTMTOPTION, TRUE
SQL_API_SQLSPECIALCOLUMNS, TRUE
SQL_API_SQLSTATISTICS, TRUE
SQL_API_SQLTABLES, TRUE
SQL_API_SQLBROWSECONNECT, TRUE
SQL_API_SQLCOLUMNPRIVILEGES, TRUE
SQL_API_SQLDATASOURCES, TRUE
SQL_API_SQLDESCRIBEPARAM, TRUE
SQL_API_SQLEXTENDEDFETCH, TRUE
SQL_API_SQLFOREIGNKEYS, TRUE
SQL_API_SQLMORERESULTS, TRUE
SQL_API_SQLNATIVESQL, TRUE
SQL_API_SQLNUMPARAMS, TRUE
SQL_API_SQLPARAMOPTIONS, TRUE
SQL_API_SQLPRIMARYKEYS, TRUE
SQL_API_SQLPROCEDURECOLUMNS, TRUE
SQL_API_SQLPROCEDURES, TRUE
SQL_API_SQLSETPOS, TRUE
SQL_API_SQLSETSCROLLOPTIONS, TRUE
SQL_API_SQLTABLEPRIVILEGES, TRUE
SQL_API_SQLDRIVERS, TRUE
SQL_API_SQLBINDPARAMETER, TRUE
SQLGetInfo Windows, UNIX
The following list shows all return codes and supported options of the ADABAS ODBC driver:
SQL_ACTIVE_CONNECTIONS rgbInfoValue = 8
SQL_ACTIVE_STATEMENTS rgbInfoValue = SHRT_MAX
SQL_DATA_SOURCE_NAME rgbInfoValue = szDSN (the open data source)
SQL_DRIVER_HDBC rgbInfoValue = the driver connect handle
SQL_DRIVER_HENV rgbInfoValue = the driver environment handle
SQL_DRIVER_HSTMT rgbInfoValue = the driver statement handle
SQL_DRIVER_NAME rgbInfoValue = "sqlodbc.dll" (16Bit)
"sqlod32.dll" (32 Bit)
"odbclib.a" (UNIX)
SQL_DRIVER_VER rgbInfoValue = > "10.01.nnnn", where nnnn
indicates the Correction Level
SQL_FETCH_DIRECTION rgbInfoValue = SQL_FD_FETCH_NEXT | SQL_FD_FETCH_FIRST | SQL_FD_FETCH_LAST | SQL_FD_FETCH_PRIOR | SQL_FD_FETCH_ABSOLUTE | SQL_FD_FETCH_RELATIVE | SQL_FD_FETCH_BOOKMARK
SQL_ODBC_API_CONFORMANCE rgbInfoValue = 1 (SQL_OAC_LEVEL2)
SQL_ODBC_VER rgbInfoValue = "02.10.0000"
SQL_ROW_UPDATES rgbInfoValue = "y"
SQL_ODBC_SAG_CLI_CONFORMANCE rgbInfoValue = 1 (SQL_OSCC_COMPLIANT)
SQL_SERVER_NAME rgbInfoValue = the servernode of the connection
SQL_SEARCH_PATTERN_ESCAPE rgbInfoValue = "\"
SQL_ODBC_SQL_CONFORMANCE rgbInfoValue = 2 (SQL_OSC_EXTENDED)
SQL_DBMS_NAME rgbInfoValue = "adabas d "
SQL_DBMS_VER rgbInfoValue = "10.01.nnnn adabas 10.01"
SQL_ACCESSIBLE_TABLES rgbInfoValue = "n"
SQL_ACCESSIBLE_PROCEDURES rgbInfoValue = "n"ODBC Library
SQL_PROCEDURES rgbInfoValue = "y"
SQL_CONCAT_NULL_BEHAVIOR rgbInfoValue = 0 (SQL_CB_NULL)
SQL_CURSOR_COMMIT_BEHAVIOR rgbInfoValue = SQL_CB_PRESERVE or
SQL_CB_DELETED
(SqlMode = ANSI)
SQL_CURSOR_ROLLBACK_BEHAVIOR rgbInfoValue = SQL_CB_PRESERVE or
SQL_CB_DELETED
(SqlMode = ANSI)
SQL_DATA_SOURCE_READ_ONLY rgbInfoValue = "n"
SQL_DEFAULT_TXN_ISOLATION rgbInfoValue = SQL_TXN_READ_COMMITTED (This value depends on the set isolation level.)
SQL_EXPRESSIONS_IN_ORDERBY rgbInfoValue = "n"
SQL_IDENTIFIER_CASE rgbInfoValue = 1 (SQL_IC_UPPER)
SQL_IDENTIFIER_QUOTE_CHAR rgbInfoValue = "\""
SQL_MAX_COLUMN_NAME_LEN rgbInfoValue = 18
SQL_MAX_CURSOR_NAME_LEN rgbInfoValue = 18
SQL_MAX_OWNER_NAME_LEN rgbInfoValue = 18
SQL_MAX_PROCEDURE_NAME_LEN rgbInfoValue = 18
SQL_MAX_QUALIFIER_NAME_LEN rgbInfoValue = 0
SQL_MAX_TABLE_NAME_LEN rgbInfoValue = 18
SQL_MULT_RESULT_SETS rgbInfoValue = "y"
SQL_MULTIPLE_ACTIVE_TXN rgbInfoValue = "y"
SQL_OUTER_JOINS rgbInfoValue = "y"
SQL_OWNER_TERM rgbInfoValue = "owner"
SQL_PROCEDURE_TERM rgbInfoValue = "stored procedure"
SQL_QUALIFIER_NAME_SEPARATOR rgbInfoValue = "."
SQL_QUALIFIER_TERM rgbInfoValue = "qualifier"
SQL_SCROLL_CONCURRENCY rgbInfoValue = SQL_SCCO_READ_ONLY | SQL_SCCO_LOCK | SQL_SCCO_OPT_ROWVER | SQL_SCCO_OPT_VALUES
SQL_SCROLL_OPTIONS rgbInfoValue = SQL_SO_FORWARD_ONLY |
SQL_SO_KEYSET_DRIVEN |
SQL_SO_DYNAMIC |
SQL_SO_STATIC
SQL_TABLE_TERM rgbInfoValue = "table"
SQL_TXN_CAPABLE rgbInfoValue = SQL_TC_ALL
SQL_USER_NAME rgbInfoValue = the active user
SQL_CONVERT_FUNCTIONS rgbInfoValue = 0x00000000L
SQL_NUMERIC_FUNCTIONS rgbInfoValue = SQL_FN_NUM_ABS | SQL_FN_NUM_ACOS | SQL_FN_NUM_ASIN | SQL_FN_NUM_ATAN | SQL_FN_NUM_ATAN2 | SQL_FN_NUM_CEILING | SQL_FN_NUM_COS | SQL_FN_NUM_COT | SQL_FN_NUM_EXP | SQL_FN_NUM_FLOOR | SQL_FN_NUM_LOG | SQL_FN_NUM_MOD | SQL_FN_NUM_SIGN | SQL_FN_NUM_SIN | SQL_FN_NUM_SQRT | SQL_FN_NUM_TAN | SQL_FN_NUM_PI
SQL_STRING_FUNCTIONS rgbInfoValue = SQL_FN_STR_LEFT | SQL_FN_STR_LTRIM | SQL_FN_STR_LENGTH | SQL_FN_STR_LCASE | SQL_FN_STR_REPLACE | SQL_FN_STR_RIGHT | SQL_FN_STR_RTRIM | SQL_FN_STR_SUBSTRING | SQL_FN_STR_UCASE
SQL_SYSTEM_FUNCTIONS rgbInfoValue = SQL_FN_SYS_USERNAME | SQL_FN_SYS_DBNAME | SQL_FN_SYS_IFNULL
SQL_TIMEDATE_FUNCTIONS rgbInfoValue = SQL_FN_TD_NOW | SQL_FN_TD_CURDATE | SQL_FN_TD_DAYOFMONTH | SQL_FN_TD_DAYOFWEEK | SQL_FN_TD_DAYOFYEAR | SQL_FN_TD_MONTH | SQL_FN_TD_WEEK | SQL_FN_TD_YEAR | SQL_FN_TD_CURTIME | SQL_FN_TD_HOUR | SQL_FN_TD_MINUTE | SQL_FN_TD_SECOND
SQL_CONVERT_BIGINT
SQL_CONVERT_BINARY
SQL_CONVERT_BIT
SQL_CONVERT_CHAR
SQL_CONVERT_DATE
SQL_CONVERT_DECIMAL
SQL_CONVERT_DOUBLE
SQL_CONVERT_FLOAT
SQL_CONVERT_INTEGER
SQL_CONVERT_LONGVARCHAR
SQL_CONVERT_NUMERIC
SQL_CONVERT_REAL
SQL_CONVERT_SMALLINT
SQL_CONVERT_TIME
SQL_CONVERT_TIMESTAMP
SQL_CONVERT_TINYINT
SQL_CONVERT_VARBINARY
SQL_CONVERT_VARCHAR
SQL_CONVERT_LONGVARBINARY rgbInfoValue = 0x00000000L
SQL_TXN_ISOLATION_OPTION rgbInfoValue =
SQL_TXN_READ_UNCOMMITTED |
SQL_TXN_READ_COMMITTED |
SQL_TXN_REPEATABLE_READ |
SQL_TXN_SERIALIZABLE
SQL_ODBC_SQL_OPT_IEF rgbInfoValue = "n"
SQL_CORRELATION_NAME rgbInfoValue = 2 (SQL_CN_ANY)
SQL_NON_NULLABLE_COLUMNS rgbInfoValue = 1 (SQL_NNC_NON_NULL)
SQL_DRIVER_HLIB rgbInfoValue = The library handle.
SQL_DRIVER_ODBC_VER rgbInfoValue = Version of the Driver Manager > 2.10
SQL_LOCK_TYPES rgbInfoValue = SQL_LCK_NO_CHANGE
SQL_POS_OPERATIONS rgbInfoValue = SQL_POS_POSITION | SQL_POS_REFRESH
SQL_POSITIONED_STATEMENTS rgbInfoValue =
SQL_PS_POSITIONED_DELETE |
SQL_PS_POSITIONED_UPDATE |
SQL_PS_SELECT_FOR_UPDATE
SQL_GETDATA_EXTENSIONS rgbInfoValue = 0x0000000F (SQL_GD_ANY_COLUMN | SQL_GD_ANY_ORDER)
SQL_BOOKMARK_PERSISTENCE rgbInfoValue = 0x00000000
SQL_STATIC_SENSITIVITY rgbInfoValue = 0x00000000
SQL_FILE_USAGE rgbInfoValue = 0
(SQL_FILE_NOT_SUPPORTED)
SQL_NULL_COLLATION rgbInfoValue = 1 (SQL_NC_LOW)
SQL_ALTER_TABLE rgbInfoValue = 0x00000003 (SQL_AT_ADD_COLUMN | SQL_AT_DROP_COLUMN)
SQL_COLUMN_ALIAS rgbInfoValue = "n"
SQL_GROUP_BY rgbInfoValue = 2
(SQL_GB_GROUP_BY_CONTAINS_SELECT)
SQL_KEYWORDS rgbInfoValue = A list of keywords (depends on SqlMode)
SQL_ORDER_BY_COLUMNS_IN_SELECT rgbInfoValue = "n"
SQL_OWNER_USAGE rgbInfoValue = 0x0000001F
(SQL_OU_DML_STATEMENTS |
SQL_OU_PROCEDURE_INVOCATION | SQL_OU_TABLE_DEFINITION | SQL_OU_INDEX_DEFINITION | SQL_OU_PRIVILEGE_DEFINITION
SQL_QUALIFIER_USAGE rgbInfoValue = 0x00000000
SQL_QUOTED_IDENTIFIER_CASE rgbInfoValue = 3 (SQL_IC_SENSITIVE)
SQL_SPECIAL_CHARACTERS rgbInfoValue = "#@$"
SQL_SUBQUERIES rgbInfoValue = 0x00000017
(SQL_SQ_COMPARISON |
SQL_SQ_EXISTS |
SQL_SQ_IN |
SQL_SQ_CORRELATED_SUBQUERIES)
SQL_UNION rgbInfoValue = 0x00000003
(SQL_U_UNION | SQL_U_UNION_ALL)
SQL_MAX_COLUMNS_IN_GROUP_BY rgbInfoValue = 16
SQL_MAX_COLUMNS_IN_INDEX rgbInfoValue = 16
SQL_MAX_COLUMNS_IN_ORDER_BY rgbInfoValue = 16
SQL_MAX_COLUMNS_IN_SELECT rgbInfoValue = 254
SQL_MAX_COLUMNS_IN_TABLE rgbInfoValue = 255
SQL_MAX_INDEX_SIZE rgbInfoValue = 255
SQL_MAX_ROW_SIZE_INCLUDES_LONG rgbInfoValue = "n"
SQL_MAX_ROW_SIZE rgbInfoValue = 0
SQL_MAX_STATEMENT_LEN rgbInfoValue = 0
SQL_MAX_TABLES_IN_SELECT rgbInfoValue = 16
SQL_MAX_USER_NAME_LEN rgbInfoValue = 18
SQL_MAX_CHAR_LITERAL_LEN rgbInfoValue = 0
SQL_TIMEDATE_ADD_INTERVALS rgbInfoValue = 0x00000000
SQL_TIMEDATE_DIFF_INTERVALS rgbInfoValue = 0x00000000
SQL_NEED_LONG_DATA_LEN rgbInfoValue = "n"
SQL_MAX_BINARY_LITERAL_LEN rgbInfoValue = 0
SQL_LIKE_ESCAPE_CLAUSE rgbInfoValue = "y"
SQL_QUALIFIER_LOCATION rgbInfoValue = 0 (The driver does not support qualifiers.)
SQLGetStmtOption Windows, UNIX
The following list shows all return codes and supported options of the ADABAS ODBC driver:
SQL_QUERY_TIMEOUT pvParam = 0 (SQL_BIND_BY_COLUMN)
SQL_MAX_ROWS pvParam = 0
SQL_NOSCAN pvParam = 0 (SQL_NOSCAN_OFF)
SQL_MAX_LENGTH pvParam = 0
SQL_BIND_TYPE pvParam = depends on SQLSetStmtOption
SQL_CURSOR_TYPE pvParam = depends on SQLSetStmtOption
SQL_CONCURRENCY pvParam = depends on SQLSetStmtOption
SQLGetTypeInfo Windows, UNIX
No restrictions.
When passing SQL_ALL_TYPES, the function SQLGetTypeInfo produces the following result table: For any other fInfoType value, the corresponding row or an empty result set is returned.
SQLParamData Windows, UNIX
No restrictions.
Note:
For LONG columns containing NULL values, see note for SQLBindParameter.
SQLPutData Windows, UNIX
No restrictions.
Note:
For LONG columns containing NULL values, see note for SQLBindParameter.
SQLSetConnectOption Windows, UNIX
Restrictions see SQLGetConnectOption.
SQLSetParam Windows, UNIX
No restrictions.
SQLSetStmtOption Windows, UNIX
No restrictions.
Note:
The driver supports the following options:
SQL_BIND_TYPE fOption = SQL_BIND_BY_COLUMN |
sizeof(ResultStruct)
SQL_CONCURRENCY fOption = SQL_CONCUR_READ_ONLY |
SQL_CONCUR_LOCK
SQL_CURSOR_TYPE fOption = SQL_CURSOR_FORWARD_ONLY |
SQL_CURSOR_KEYSET_DRIVEN |
SQL_CURSOR_DYNAMIC |
SQL_CURSOR_STATIC
SQL_ROWSET_SIZE fOption = <number of rowset rows>
SQL_SIMULATE_CURSOR fOption = SQL_SC_NON_UNIQUE
SQL_USE_BOOKMARKS fOption = SQL_UB_OFF |
SQL_UB_ON
SQLSpecialColumns Windows, UNIX
No restrictions.
SQLStatistics Windows, UNIX
No restrictions.
SQLTables Windows, UNIX
No restrictions.
Note:
The following types of tables (szTableType) are supported:
"alias", "result", "snapshot", "system", "system table", "table", "unloaded", "view".