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

Chapter 10 173
Technical Articles
IMAGE/SQL with TurboIMAGE/XL Enhancements
For SQL access, the only step necessary to use the above enhancements
pertaining to relational access, is to perform DETACH, if attached, and
ATTACH.
Important Information
1. If you have third-party indexing (TPI) enabled for the database and
want to create B-Tree indices, obtain the correct version of the
third-party software which recognizes this coexistence. Otherwise,
you will get run-time errors returned by third-party software for new
modes of DBFIND, DBINFO, and other utility commands.
2. The Optimizer derives an index scan based on the current statistics
for the data set. Hence, it may select an index on the column not
used in the SQL statement.
ODBCLink/SE
In this release, IMAGE/SQL is bundled with a new 16-bit and 32-bit
ODBC driver, ODBCLink/SE, which is a replacement for the ODBC
driver HP PC API. ODBCLink/SE is an implementation of Microsoft's
Open Database Connectivity (ODBC) interface that enables Microsoft
Windows based applications and tools to access TurboIMAGE/XL data
on the HP3000 in a client/server environment. In such an environment,
the application developers and end-users can take advantage of the
PC's graphical user interface (GUI) and processing power, while relying
on the security, integrity, and database management capabilities of
IMAGE/SQL. The client can run under Microsoft Windows 3.1 or 3.11,
Windows95, or Windows NT V3.51 or V4.0. Connection via Winsock is
available in 16-bit and the new 32-bit version. The driver can be used in
two ways: either by direct calls from a Windows program or through an
ODBC-compliant application such as Microsoft Access and Visual
Basic.
A data migration tool is provided to migrate data sources created for
the current HP PC API to ODBCLink/SE. Once the data sources have
been identified, the translation is performed automatically.
The ODBCLink/SE server runs on MPE/iX 5.0 or later releases.
ODBCLink/SE is ODBC Level 2 compliant with a few exceptions. For
more information, refer to the article, “Introducing ODBCLink/SE,” in
this Communicator 3000. The ODBCLink/SE Reference Manual is
bundled with IMAGE/SQL.