HPlogo   Communicator 3000 MPE/iX Release 6.0 (Platform Software Release C.60.00):
HP 3000 MPE/iX Computer Systems > Chapter 5 Application Development

5.7: IMAGE/SQL and TurboIMAGE/XL Overview

MPE documents

Complete PDF

 

Table of Contents

Index

 

⇓ Page Bottom

⇑ Page Top

  

QUERY/iX Enhancements Overview

Features in ALLBASE/SQL Version G3

by Bharati Desai
Commercial Systems Division

Overview

This is an overview of the enhancements to IMAGE/SQL and TurboIMAGE/XL that have been implemented since the release MPE/iX 5.5 (C.55.00). For additional information, refer to the following articles in Chapter 10, "Technical Articles":
  • IMAGE/SQL with TurboIMAGE/XL Enhancements

  • TurboIMAGE/XL Dynamic Detail Dataset Expansion (DDX) Problem

  • IMAGE/SQL Dynamic Dataset Expansion for Master Datasets (MDX)

  • New Features in ALLBASE/SQL Version G3

  • Introducing ODBCLink/SE
The highlights of this release of IMAGE/SQL, version B.G2.07, and TurboIMAGE/XL, version C.07.14 are the following:
  • B-Tree indices enhancement

  • ODBCLink/SE, 16-bit and 32-bit ODBC driver, bundled with IMAGE/SQL

  • Support for third-party composite indices

  • Scalability

  • IMAGE/SQL Dynamic Dataset Expansion for Master Datasets (MDX)

  • Additional manuals bundled with IMAGE/SQL

  • Manuals available on HP Instant Information CD-ROM:
    • HP IMAGE/SQL Administration Guide
    • TurboIMAGE/XL Database Management System Reference Manual

Updating from an Earlier Release

If you are updating from an earlier release of IMAGE/SQL, you must DETACH databases which are ATTACHed to one or more DBEnvironments and ATTACH again in order to benefit from the enhancements. For performance improvement, issue the UPDATE STATISTICS command of ISQL for each of the tables you access frequently. If you have created SQL data using an earlier release of IMAGE/SQL, perform the ALLBASE/SQL migration to migrate your DBEnvironment to the current G3 format. For more information, refer to the ALLBASE/SQL Database Administration Guide.

TurboIMAGE/XL is enhanced to increase the concurrency of modification intrinsics, DBPUT, DBDELETE, and DBUPDATE (Critical Item Update feature ON). To use this enhancement, your database must be activated to use the Dependency Semaphore. To achieve this, the ENABLE and DISABLE commands of DBUTIL introduce a new option, DSEM. The default for DSEM is DISABLED.

Important Information

  1. The default for Critical Item Update option is now changed from DISALLOWED to ALLOWED.

  2. A jumbo data set cannot be enabled for dynamic expansion.

  3. 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.

ODBCLink/SE

IMAGE/SQL is bundled with ODBCLink/SE, which is a replacement for 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 HP 3000 in a client/server environment.

HP PC API will no longer be distributed with IMAGE/SQL software. It can co-exist with ODBCLink/SE but will no longer be enhanced. For more information, refer to the article, "Introducing ODBCLink/SE," in this Communicator 3000 and the manual, ODBCLink/SE Reference Manual, which is bundled with IMAGE/SQL.


QUERY/iX Enhancements Overview

Features in ALLBASE/SQL Version G3