HP 3000 Manuals HP 3000 Manuals
Chapter 3 Application Development
Introducing HP IMAGE/SQL
by Bharati V. Desai
Commercial Systems Division
What is HP IMAGE/SQL?
HP IMAGE/SQL is the next generation version of the TurboIMAGE database
management system. It is an enhanced combination of TurboIMAGE/XL and
what was formerly known as ALLBASE/Turbo CONNECT (ATC). HP IMAGE/SQL
provides relational access to your TurboIMAGE/XL data using the
industry-standard Structured Query Language (SQL) and now includes both
read and write capability using ANSI standard fuctionality. ATC provided
only read capability.
Closely tuned to the architecture of Hewlett-Packard computers, HP
IMAGE/SQL gives you flexibility in designing and using new SQL database
applications on a small or large scale. At the same time, you can
continue to use your existing TurboIMAGE/XL applications without any
noticeable differences. You do not have to convert, recompile, or make
changes to your existing applications. Your TurboIMAGE/XL database can
now be accessed simultaneously by SQL applications as well as by your
existing TurboIMAGE/XL applications. If you want, you can continue to
enhance your existing TurboIMAGE/XL applications or even develop new
ones.
HP IMAGE/SQL includes the client/server components HP ALLBASE/PC API and
ALLBASE/NET; therefore, PC client applications using industry-standard
SQL can use HP IMAGE/SQL to access TurboIMAGE/XL data on an HP 3000 host
system. With the increased usage of PCs and rapid adoption of
client/server technology, HP IMAGE/SQL extends the availability of your
TurboIMAGE/XL data to report writers, 4GLs, and other applications
running on a PC network.
To summarize, you benefit in the following ways:
* By leveraging your investment.
Your existing investment in TurboIMAGE/XL is preserved while you
take advantage of relational technology.
* By accessing new tools not previously available to TurboIMAGE/XL
users.
The purchasable SQL client/server tools allow you to view data
from TurboIMAGE/XL, ALLBASE/SQL, or third-party databases.
* By benefiting from productivity gains.
SQL uses a common interface to access TurboIMAGE/XL, ALLBASE/SQL,
and third-party SQL databases. Productivity improves when you can
use the same interface to access different types of databases.
Components of HP IMAGE/SQL
HP IMAGE/SQL includes TurboIMAGE/XL, certain components of ALLBASE/SQL,
and a database administration tool called IMAGESQL (formerly known as
ATCUTIL) that links them together. The components of HP IMAGE/SQL are:
TurboIMAGE/XL A set of programs and procedures to create and
maintain TurboIMAGE/XL databases.
ALLBASE/SQL ALLBASE/SQL components such as Interactive Structured
Query Language (ISQL), SQLUtil, SQLGEN, and
preprocessors to provide relational access to
TurboIMAGE/XL databases.
ISQL lets you enter SQL statements at the keyboard
and observe query results, messages, and other
information on a video display. ISQL is the main
tool for HP IMAGE/SQL programmers and database
administrators to create and modify DBEnvironments,
load and unload data, and enter SQL queries.
SQLUtil is a database administrator's tool for
maintaining relational database environments.
SQLGEN is a database administrator's tool that
generates the commands to recreate all or part of the
existing database environment. These commands can
later be used to recreate the database environment.
Preprocessors are tools to convert source programs
containing SQL statements into source code that can
be compiled in a programming language of your choice,
such as C, COBOL, FORTRAN, or Pascal.
IMAGESQL A dabase administrator's tool, formerly known as
ATCUTIL, to manage TurboIMAGE/XL databases in a
relational access environment.
HP ALLBASE/SQL PC Software that provides access to ALLBASE/SQL and
API TurboIMAGE/XL databases residing on HP-PA RISC
database servers from a Microsoft window-based PC.
You need to use one of several available PC
client/server or decision support tools to build your
application or query.
ALLBASE/NET Works with HP ALLBASE/SQL PC API to connect users
with databases residing on an HP 3000 server.
IMAGESQL A dabase administrator's tool, formerly known as
ATCUTIL, to manage TurboIMAGE/XL databases in a
relational access environment.
Information Access A component of the Hewlett-Packard Information Access
Server SQL/iX and is the HP 3000-based data server.
How Do You Get HP IMAGE/SQL?
HP IMAGE/SQL is available to TurboIMAGE/XL customers through the HP
IMAGE/SQL upgrade program. You must have TurboIMAGE/XL on your support
contract to get HP IMAGE/SQL. If you purchase a new HP-PA RISC computer
system, you automatically get HP IMAGE/SQL.
This new HP IMAGE/SQL upgrade program is a special, limited-time offering
to provide the HP IMAGE/SQL upgrade to support customers through their
support contract. It is formally offered from June 1, 1993 to June 1,
1994 or until every customer has had an opportunity to renew their
contract for HP IMAGE/SQL.
This program is the result of extensive customer requests through
SIGIMAGE user groups and responses to a worldwide Interex customer
survey, which indicated that 80 percent of Hewlett-Packard support
customers would welcome an HP IMAGE/SQL upgrade product with a support
price increase. User level support price increases were established and
modified based on customer responses and sensitivity to proposed price
increases.
An initial letter was sent to all existing support customers from
Hewlett-Packard and the Interex user group explaining the addition of HP
IMAGE/SQL upgrade support to every support agreement at quote renewal
time.
Monthly support price increases are based on MPE/iX user levels. At your
renewal time, you will receive a quote reflecting the HP IMAGE/SQL
upgrade and the addition of support at the MPE/iX user level. You have
an option to accept or decline the offer. (If you are in the U.S., you
will also be contacted by telemarketing prior to quote renewal to
determine your position on the offer.)
A second letter accompanies your renewal quote. This letter reiterates
the HP IMAGE/SQL upgrade program benefits and prices and the options
available regarding HP IMAGE/SQL support. You may choose to lower your
MPE/iX user level license to more accurately reflect current operating
environments. This provides a lower HP IMAGE/SQL upgrade support price.
After you renew your contract with HP IMAGE/SQL, a product tape will be
sent to you. The U.S. telemarketing group handles requests for the U.S.
market. U.S. customers can call 1-800-437-9140. Commercial Systems
Division is coordinating these efforts for customers outside the U.S.
These customers should have received a FAX request form with the initial
customer letter.
Additional monthly support prices by user level are as follows:
Users License-to-Use Phone-in-Assistance
(BasicLine) (ResponseLine)
1 to 8 $10 $20
1 to 20 20 40
1 to 32 30 60
1 to 40 35 75
1 to 64 50 100
1 to 100 100 200
1 to 128 125 250
1 to 160 145 285
1 to 256 150 300
1 to 384 165 325
Unlimited 165 325
Additional Information
HP IMAGE/SQL can be automatically installed using HP AUTOINST.
The product number for HP IMAGE/SQL is 36385B. The manuals included with
HP IMAGE/SQL are:
* HP IMAGE/SQL Administration Guide (36385-90001)
* Getting Started With HP IMAGE/SQL (36385-90008)
* HP ALLBASE/SQL PC API User's Guide (B2463-90001)
Microsoft WindowsTM and Microsoft(R) are U.S. registered trademarks of
Microsoft Corporation.