HP 3000 Manuals HP 3000 Manuals
Supported Functions
The ODBC functions are listed here for application software developers.
These functions are supported by the PC API ODBC driver at the time of
publication of this manual. Refer to the README.HP file included with
the PC API product for further developments.
You can use the ODBC SQLGetFunctions call for a list of the supported PC
API ODBC driver functions. Descriptions and conformance designations are
listed in ODBC API Reference included in the Microsoft Software
Development Kit (SDK).
Functions that are not completely implemented are noted by an R in
parenthesis and are discussed below this list.
SQLAllocConnect
SQLAllocEnv
SQLAllocStmt
SQLBindCol
SQLCancel
SQLColAttributes (R1)
SQLColumns
SQLConnect
SQLDataSources
SQLDescribeCol
SQLDisconnect
SQLDriverConnect
SQLError
SQLExecute
SQLExecDirect
SQLFetch
SQLFreeConnect
SQLFreeEnv
SQLFreeStmt
SQLGetConnectOption
SQLGetCursorName
SQLGetFunctions
SQLGetInfo (R3)
SQLGetTypeInfo
SQLNumResultCols
SQLPrepare
SQLRowCount
SQLSetConnectOption (R2)
SQLSetCursorName
SQLSetParam
SQLSetStmtOption (R2)
SQLSpecialColumns
SQLStatistics
SQLTables
SQLTransact
R1: The following SQLColAttributes options are implemented; the others
will receive a return value of 'Not Implemented'.
SQL_COLUMN_COUNT
SQL_COLUMN_NAME
SQL_COLUMN_TYPE
SQL_COLUMN_LENGTH
SQL_COLUMN_PRECISION
SQL_COLUMN_SCALE
SQL_COLUMN_DISPLAY_SIZE
SQL_COLUMN_NULLABLE
R2: The following SQLSetStmtOptions options are supported:
SQL_AUTOCOMMIT 0=On (default)
SQL_MAX_LENGTH 0=no max length (default)
used with LONGVARCHAR and LONGVARBINARY
SQL_QUERY_TIMEOUT 0 (default) supported TIMEOUT
environment variable supported
SQL_MAX_ROWS 0 (default) supported maximum number
of rows to return from a select statement
R3: All options are supported by the SQLSetConnectOption and
SQLGetConnectOption commands, although some set values are disallowed
(driver not capable).
SQL_ACCESS_MODE READ_ONLY not supported
SQL_LOGIN_TIMEOUT only infinite value supported
(TIMEOUT environment variable used)
SQL_OPT_TRACE supported by Driver Manager
SQL_OPT_TRACEFILE supported by Driver Manager
SQL_TXN_ISOLATION
supported:
SQL_TXN_READ_UNCOMMITTED (Read Uncommitted (RU))
SQL_TXN_READ_COMMITTED (Read Committed (RC))
SQL_TXN_REPEATABLE_READ (Repeatable Read (RR))
SQL_TXN_SERIALIZABLE (Repeatable Read (RR))
For information on isolation levels, refer to the "Isolation Levels"
section in this chapter.
R3: The following options for SQLGetInfo are supported; the others will
receive a return value of S1C00 - "Driver not capable":
SQL_ACTIVE_CONNECTIONS
SQL_ACTIVE_STATEMENTS
SQL_DRIVER_VERSION
SQL_ODBC_API_CONFORMANCE
SQL_ODBC_SQL_CONFORMANCE
SQL_PROCEDURES
SQL_SEARCH_PATTERN_ESCAPE
--------------------------
SQL_DATABASE_NAME
SQL_DBMS_NAME
SQL_DBMS_VER
--------------------------
SQL_CURSOR_COMMIT_BEHAVIOR
SQL_CURSOR_CONCAT_NULL_BEHAVIOR
SQL_CURSOR_ROLLBACK_BEHAVIOR
SQL_DATA_SOURCE_READ_ONLY
SQL_EXPRESSIONS_IN_ORDERBY
SQL_IDENTIFIER_QUOTE_CHAR
SQL_MAX_COLUMN_NAME_LEN
SQL_MAX_OWNER_NAME_LEN
SQL_MAX_QUALIFIER_NAME_LEN
SQL_MAX_TABLE_NAME_LEN
SQL_OUTER_JOINS
SQL_QUALIFIER_NAME_SEPARATOR
SQL_TXN_CAPABLE
SQL_TXN_ISOLATION_OPTIONS
-------------------------
SQL_CONVERT_FUNCTIONS
SQL_NUMERIC_FUNCTIONS
SQL_STRING_FUNCTIONS
SQL_SYSTEM_FUNCTIONS
SQL_TIMEDATE_FUNCTIONS
--------------------------
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_LONGVARBINARY
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