HP 3000 Manuals

HP ALLBASE/SQL PC API User's Guide

What Is PC API? 

PC API allows a user to access ALLBASE/SQL on HP-PA RISC database servers
from a Microsoft Windows-based PC. PC API is based on the popular Gupta
Technologies, Inc.  C/API, so existing client/server applications that
are based on the Gupta C/API can be ported easily and quickly to access
ALLBASE/SQL.

As shown in Figure 1-1 , PC API is part of a client/server environment
where application software resides on the PC client and ALLBASE/SQL
resides on the database server.  In this environment, 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 ALLBASE/SQL.

In addition, since IMAGE/SQL is based on ALLBASE/SQL, PC API can be used
to access IMAGE/SQL database servers as well.

Client Environment 

PC API and application software reside on the PC client.  With PC API and
application software (4GL tools or 3GL applications), you can develop SQL
applications, generate reports, and query ALLBASE/SQL on the HP 3000
server.

Server Environment 

The networked HP 3000 Series 900 and ALLBASE/SQL provide the relational
database environment on the server.  Your HP 3000 server provides
security through the MPE/iX logon system.  The database management
capabilities and security of ALLBASE/SQL are also utilized.

ALLBASE/SQL offers many features that you can use to your advantage from
the PC client.  Some of them include:

   *   stored procedures
   *   rules
   *   inner and outer joins
   *   integrity constraints
   *   manipulation of databases in a wide variety of native languages

To learn about these and other features, refer to the ALLBASE/SQL 
Database Administration Guide the ALLBASE/SQL Reference Manual, or the
appropriate ALLBASE/SQL application programming bulletin or guide.  These
manuals list the new features for each release in the preface.

The Connecting Link 

PC API links the client to the server with a collection of dynamic link
libraries (DLLs) and other files that reside on the client and run under
Microsoft Windows.  PC API routes requests, made from the PC client
application, over the network to an ALLBASE/SQL database on the database
server, and returns replies to the client application process.

A listener process establishes the connection between the PC client
application and the target database on the server.  The listener works
with both HP ThinLAN 3000/XL and NetWare/XL data communications software.


          Figure 1-1.  The Client/Server Environment 

MPE/iX 5.0 Documentation