HP Integrity NonStop H-Series - Manual (Page 14)

Tracing
HP-UX, Linux 32 and Linux 64
The trace information is captured in a log file. You can enable or disable tracing and specify
the trace file name in MXODSN file. When using the unixODBC driver manager, you can enable
the driver tracing by setting the following environment variables:
•
HPODBC_TRACE_LEVEL. For trace values, see “MXODSN and ODBCDSN file formats”
(page 30) .
•
HPODBC_TRACEFILE_NAME to set the trace file name. The PID and current time are
appended to this name to form the final trace file name.
•
HPODBC_TRACEFILE_SIZE to set the maximum trace file size. The default file size is 1 GB.
OSS
The trace information is captured in an OSS log file. You can enable or disable tracing and
specify the trace file name in ODBCDSN file.
Windows
You can trace the entry and exit calls from the Microsoft driver manager to the driver, contents
of the buffers (except password buffers), and activity between the driver and transport layer.
To get the tracing help, click the Help button in the Microsoft ODBC Data Source Administrator
panel.
NOTE: For information about MXCS tracing, see SQL/MX Connectivity Service Administrative
Command Reference manual.
Object naming and mapping
The drivers can access SQL/MX database objects and SQL/MP objects that have an alias.
ANSI name type
Only ANSI name types are supported for SQL/MX database objects. You can configure the default
catalog and schema names to qualify table names in the queries. The name format is:
catalog.schema.object-name
ANSI names have a maximum of 128 characters for each part of the name (not including the dots).
ANSI names for SQL/MX objects
ANSI names for SQL/MX database objects are registered in the metadata in SQL/MX tables.
ANSI alias names for SQL/MP objects
Only ANSI name types are supported for SQL/MP database objects. Alias names are ANSI
standard names that map to physical Guardian names for existing SQL/MP objects.
To add ANSI alias names for SQL/MP tables, use the command CREATE SQLMP ALIAS, which
stores the alias name in the SQL/MX catalog. For more information about CREATE SQLMP ALIAS
command, see the SQL/MX 3.x Reference Manual.
Unsupported ODBC APIs
The drivers are ODBC 3.5 compliant. Table 1 (page 15) lists the unsupported ODBC APIs.
14 Overview