Neoview ODBC Drivers Manual (R2.5)

Table 1-1 Release Considerations and Restrictions for Windows Driver (continued)
This function does not support pattern value arguments
for table names, and returns an optimal set of columns
that uniquely identifies a row in the table information for
a specified table name.
SQLSpecialColumns Function
This function does not support pattern value arguments
for table names, and returns index information for a
specified table name.
SQLStatistics Function
Returns all schemas defined in the SQL metadata.
Returns all object types supported by SQL.
SQLTables Function
When SchemaName is:
SQL_ALL_SCHEMAS
When TableType is:
SQL_ALL_TABLE_TYPES
The ODBC driver uses SQL_ATTR_METADATA_ID to
determine whether to upshift a table name. This applies
for catalog API to SQLTables, SQLPrimaryKey, and
SQLStatistics. This does not apply to SQLColumns.
SQL Table Names
SQL Schema Names
SQLCancel Function
If SQLCancel is called and no processing is being done
ODBC 1.0/2.0
SQLCancel has the same effect as SQLFreeStmt with the SQL_CLOSE option.
ODBC 3.0
SQLCancel has no effect at all. To close the cursor, an application should call SQLCloseCursor.
If SQLCancel is called and a query is running
ODBC 1.0/2.0/3.0
The HP Neoview ODBC driver makes a best effort to gracefully cancel a running query. If the
query is successfully cancelled, it returns SQLCODE 8007.
If an executing query does not finish within 120 seconds after the request to cancel is accepted,
the master executor is stopped. In this case, the application must detect a connection termination
(SQLSTATE=08S01 or 08S02) and reconnect. This applies to queries that use the CALL statement,
the PREPARE statement, DDL and utility queries, and occasionally to other queries.
NOTE: This can impact statement handles that share the connection.
To ignore SQLCancel calls, set SQL_ATTR_IGNORE_CANCEL = 1 for the server data source.
Traces
You can trace activity for the ODBC client. The following data is collected:
• Entry and exit calls from Microsoft ODBC driver manager to the HP Neoview ODBC driver.
• Contents of the buffers, except password buffers.
• Activity between the HP Neoview ODBC driver and the transport layer.
For more information about client tracing, click the Help button on the Client Microsoft
Administrator.
For information about configuring client data source traces, see “Tracing Client Data Sources”.
24 HP Neoview ODBC Driver Overview for Windows