Neoview ODBC Drivers Manual (R2.4)

Table 1-1 Release Considerations and Restrictions for Windows Driver (continued)
An ODBC application can call SQLSetStmtOption with
the SQL_QUERY_TIMEOUT option to specify the number
of seconds to wait for a query to execute. The
SQL_QUERY_TIMEOUT option protects the NDCS server
and ODBC client from long running queries. If a query
exceeds the specified time before the data source returns
the result set, the HP Neoview ODBC driver returns
HYT00 (Timeout expired) to the ODBC client. When the
query times out, the client gets disconnected from the
server, resulting in a communication link failure. The
client has to reconnect to the server after any query
timeout event.
SQL_QUERY_TIMEOUT Option
For information about SQLCancel function, see
“SQLCancel Function” (page 18).
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
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 tries to stop the server. If the attempt is successful, SQLCancel
returns a SQL_SUCCESS_WITH_INFO with SQLSTATE 01000 and the warning messages
"Application must reconnect since the server has been stopped." This can have an impact on
statement handles that share the connection. To prevent SQLCancel from stopping the server
when a query is running, you can set the SQL_ATTR_IGNORE_CANCEL attribute at the server
data source.
18 HP Neoview ODBC Driver Overview for Windows