HP 3000 Manuals HP 3000 Manuals
What Is PC API? [REV BEG] PC API is Hewlett-Packard's open, client/server connectivity interface that enables Microsoft Windows based applications and tools to access ALLBASE/SQL and IMAGE/SQL databases in a client/server environment. See Figure 1-1 . 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 and IMAGE/SQL. PC API supports two interfaces: * Open Database Connectivity (ODBC) from Microsoft Corporation. * Gupta C/API from Gupta Technologies, Inc. ODBC is based on the Call Level Interface (CLI) specification from the SQL Access Group. The Gupta C/API interface is a defacto standard for accessing databases in a client/server environment. Application software can use either or both interfaces. This guide contains an independent chapter for each interface.[REV END]
NOTE Because IMAGE/SQL is based on the ALLBASE/SQL interface, all references to ALLBASE/SQL throughout this manual include IMAGE/SQL.
Client Environment PC API and application software reside on the PC client. With PC API and application software you can develop SQL applications, generate reports, and query ALLBASE/SQL on the database server. Table 1-1 lists some of the application software that is compatible with PC API. Table 1-1. Application Software ----------------------------------------------------------------------------------------------- | | | | | Software | Version | Interface | | | | | ----------------------------------------------------------------------------------------------- | | | | | Cognos Impromptu | 2.0 | ODBC | | | | | ----------------------------------------------------------------------------------------------- | | | | | Crystal Reports | 2.0, 3.0 | ODBC, Gupta | | | | | ----------------------------------------------------------------------------------------------- | | | | | Excel | 5.0 | ODBC | | | | | ----------------------------------------------------------------------------------------------- | | | | | Gupta Quest | 2.1E | Gupta | | | | | ----------------------------------------------------------------------------------------------- | | | | | Gupta SQL Windows | 4.1 | Gupta | | | | | ----------------------------------------------------------------------------------------------- | | | | | HP Information Access | A.06.00.001 | ODBC | | | | | ----------------------------------------------------------------------------------------------- | | | | | Lotus 1-2-3 | 4.01 | ODBC | | | | | ----------------------------------------------------------------------------------------------- | | | | | Microsoft Access | 1.1 | ODBC | | | | | ----------------------------------------------------------------------------------------------- | | | | | Visual Basic | 3.0 | ODBC | | | | | ----------------------------------------------------------------------------------------------- | | | | | Word for Windows | 6.0 | ODBC | | | | | ----------------------------------------------------------------------------------------------- | | | | | Powersoft PowerBuilder | 3.0 | ODBC, Gupta | | | | | ----------------------------------------------------------------------------------------------- | | | | | Q+E Database Editor | 5.05 | Gupta | | | | | ----------------------------------------------------------------------------------------------- | | | | | Q+E Database Library | 2.0 | Q+E ODBC (requires | | | | Gupta) | | | | | ----------------------------------------------------------------------------------------------- | | | | | Q+E MultiLink/VB | 2.0 | Q+E ODBC (requires | | | | Gupta) | | | | | ----------------------------------------------------------------------------------------------- | | | | | Trinzic Forest & Trees | 3.1 | ODBC, Gupta | | | | | ----------------------------------------------------------------------------------------------- Server Environment The networked HP 3000 Series 900 and ALLBASE/SQL provide the relational database environment on the server. Security is provided by the MPE/iX logon system and ALLBASE/SQL.
NOTE System requirements for a database server on the HP 9000 are in the HP PC API User's Guide for ALLBASE/SQL.
ALLBASE/SQL offers many features that you can use to your advantage from the PC client. Some of them include: * rules * inner and outer joins * integrity constraints * manipulation of databases in a wide variety of native languages 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. 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/iX and NetWare/iX server networking software.Figure 1-1. The Client/Server Environment
![[]](../../pic3k/M012945/FFN23c50.gif)