Neoview ODBC Drivers Manual (R2.5)

Table 2-1 Release Considerations and Restrictions for HP Neoview ODBC Drivers for UNIX (continued)
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
Pthreads and the HP-UX ODBC Driver
If you use asynchronous IO/multi-threaded applications and the HP ODBC drivers on HP-UX,
your application must explicitly link in the pthread library ahead of other libraries.
Traces
You can trace activity for the ODBC client. The following data is collected:
• Entry and exit calls to the HP Neoview ODBC drivers
• Contents of the buffers, except password buffers
• Activity between the HP Neoview ODBC drivers and the transport layer
Using the Driver With a Third Party Driver Manager
• If you are using an external driver manager, you must point to libhpodbc_drvr.x (32–bit)
or libhpodbc_drvr64.x (64–bit) and not to libhpodbc.
• The driver (libhpodbc_drvr.x (32–bit) or libhpodbc_drvr64.x (64–bit)) has been verified with
iODBC and unixODBC driver managers.
NOTE: The driver libhpodbc_drvr.x needs to call the SQLGetPrivateProfileString function
to read the odbc.ini (or equivalent) files. This function is exported by the driver manager
from a DLL typically named libodbcinst.x. If the driver is unable to locate this function, the
driver gives an error message “Unable to find exported symbol SQLGetPrivateProfileString.”
In this case, make sure you set the DLL path so that the driver can locate this DLL or link
this DLL when you build your application.
• These driver managers, as well as documentation, can be found at these Web sites:
http://www.iodbc.org/
http://www.unixodbc.org/
• The three environment variables that control tracing are:
— HPODBC_TRACE_LEVEL — sets trace level (ERROR, WARNING, CONFIG, INFO,
or DEBUG)
— HPODBC_TRACEFILE_NAME — specifies the name of the log file
— HPODBC_TRACEFILE_SIZE — specifies the maximum files size of the log files
Pthreads and the HP-UX ODBC Driver 39