Neoview ODBC Drivers Manual (R2.2)

ANSI names have a maximum of 128 characters for each part of the name (not including the
dots).
Ensure the catalog name is not qualified while defining your schema.
Password Expiration
NDCS is configured to allow the driver to display password expiration warnings. You can change
your password during the current session in one of two ways:
• Provide the old and new passwords in a dialog box that displays with the expiration warning.
If you enter an invalid password, the connection is terminated.
You can also cancel the password change and just continue with the current session.
• Provide the old and new passwords in the connection string:
PWD=old_password, new_password, new_password
Release Considerations and Restrictions
Table 2-1 Release Considerations and Restrictions for Linux , HP-UX, and IBM AIX® Drivers
If your application relies on a standard driver manager
to load the HP ODBC library, the library, libhpodbc_drvr,
should be used. Refer to your standard driver manager
documentation for information on how to configure an
ODBC library with libhpodbc_drvr.
The library, libhpodbc, which provides the functionality
of the driver manager and driver, is not suitable for
loading from another driver manager.
HP ODBC driver software
An ODBC client application can set the schema for an
ODBC client data source by editing your MXODSN file.
If an ODBC client does not set the schema for an ODBC
client data source, NDCS defaults to USR. Note:
• Schema names follow SQL rules and are case sensitive.
• Schema names that are defined by default are not
recognized by NDCS for client data sources.
Schema
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
Release Considerations and Restrictions 25