Neoview ODBC Drivers Manual (R2.2)

Table 1-1 Release Considerations and Restrictions for Windows Driver (continued)
In an ODBC 2.0 application, the HP Neoview ODBC driver
implements the SQLCancel function as an SQLFreeStmt
with the SQL_CLOSE option. If the query is running, HP
Neoview ODBC driver tries to stop the server. If the
attempt is successful, the client application receives an
error and must reconnect.In an ODBC 3.0 application with
a query (or queries) running, the HP Neoview ODBC
driver behaves as it does for a 2.0 application. In an ODBC
3.0 application with no query running, the HP Neoview
ODBC driver does not implement the SQLCancel function.
The application is responsible for closing the cursor.
SQLCancel Function
This function does not support pattern value arguments
for table names, and returns keys information for a
specified table name.
SQLPrimaryKeys Function
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
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”.
INFOSTATS Command
INFOSTATS is a pass-through command that collect statistics for a prepared statement. Statistics
are returned to the ODBC application as a result set as soon as the PREPARE is finished. The
result set has these columns:
• Query ID (SQL_CHAR)
• CPUTime (SQL_DOUBLE): An estimate of the number of seconds of processor time it might
take to execute the instructions for this query. A value of 1.0 is 1 second.
• IOTime (SQL_DOUBLE): An estimate of the number of seconds of I/O time (seeks plus data
transfer) to perform the I/O for this query.
Traces 19