Neoview ODBC Drivers Manual (R2.4)

In this example, INFOSTATS is issued directly on the SQL statement. Again, use SQLFetch to
retrieve the result:
SQLExecDirect:
In: hstmt = 0x003B1968
szSqlStr = "infostats "select * from t1"", cbSqlStr = -3
Return: SQL_SUCCESS=0
Get Data All:
"QueryID", "CPUTime", "IOTime", "MsgTime", "IdleTime", "TotalTime"
"Cardinality"
"MXID115000897212014649972695973_60_STMT_INFOSTATS
", 0.0986710164301648, 0.1023000010183761, 129.0 0.0980000013441895,
0.0980000013441895, 0.1023000010183761, 129.0
1 row fetched from 7 columns.
Unsupported ODBC API Functions and Data Types
API Functions
This release of HP Neoview ODBC driver does not support the following ODBC 3.51 API
functions:
• SQLBulkOperations
• SQLFetchScroll - supported for SQL_FETCH_NEXT attribute only
• SQLSetScrollOption
For descriptions of the ODBC API functions, see “ODBC API Functions”.
Data Types
NDCS does not support the following ODBC data types:
• BIT
• TINYINT and TINYINT UNSIGNED
• BINARY
• VARBINARY
• LONG VARBINARY
For more information about data types, see “ODBC Data Types”.
Restricted ODBC API Functions
SQLBindParameter
The SQLBindParameter function has these restrictions:
• SQL_DEFAULT_PARAM is not supported for the pcbValue argument.
• The SQL_LEN_DATA_AT_EXEC(length) macro is not supported for the pcbValue
argument.
SQLPutData
The SQLPutData function can send data in parts only for the SQL_LONGVARCHAR data type.
For all other data types, only the latest value in the rgbValue argument is used.
Unsupported ODBC API Functions and Data Types 23