Communicator 3000 MPE/iX Release 6.0 (Platform Software Release C.60.00) (30216-90269)

234 Chapter 10

Technical Articles

Introducing ODBCLink/SE

The following ALLBASE/SQL and IMAGE/SQL statements are not

supported because they have been replaced by other functions resident

on the client:

Table 10-9 Replaced Functions

Utilities

The utilities provided with ODBCLink/SE do the following:

• Test and verify that the driver is functioning correctly.

• Determine which version of ODBCLink/SE is running.

• Delete unwanted drivers.

• Delete unwanted translation DLL's.

Tools on the Server

The following server tools are available to allow monitoring of the

ODBCLink/SE listener process:

• HP GlancePlus/XL (HP 3000) Program

• HP GlancePlus/UX (HP 9000) Program

• HP-UX Process Status (ps) Command

• Monitoring ALLBASE/SQL Activity with SQLMON

• ODBCUTSE for testing/troubleshooting the host connection or table

access

• The parameter to have error messages logged to the ODBCLOG ﬁle:

Trace SQL calls on the server.

Tools on the Client

The tools on the client that you can use to monitor or troubleshoot the

ODBCLink/SE client process:

• The conﬁguration parameter, Trace ODBC calls on the

client, is used to log information to the ODBCLink.LOG ﬁle.

• The application, Dr. DeeBeeSpy, is used to trace calls to the ODBC

driver. Dr. DeeBeeSpy is shipped with ODBCLink/SE.

CONNECT DISCONNECT

RELEASE RESET

SET CONNECT SET MULTITRANSACTION

START DBE START DBE NEW

START DBE NEWLOG STOP DBE