Using PC-based Application Softw are

From your PC, you can use Microsoft Windo ws-based application softw are (4GLs, 3GLs, query or report writing tools) to access ALLBASE/SQL. Simply cop y the HP PC API installation ￿le, HPPCAPI.PUB.SYS, to y our PC and follo w the installation directions. For more information refer to the HP PC API User's Guide for ALLBASE/SQL and IMAGE/SQL.

Conditions for Connecting to a Remote DBEnvironment

When an application issues a command to connect to a DBEn vironment, a remote connection is attempted if one of the following conditions exist on the clien t:

There is no ￿le with that name on the clien t system.

There is a ￿le with that name but it is not a DBECon ￿le on the clien t system.

When the remote connection is attempted, a local error message is held in a bu￿er. If the remote connection is not successful, the remote error message is added to the error message bu￿er, as sho wn in ￿gure 3-1. Next, the w arning message 29007 (that iden ti￿es the preceding error as pertaining to a remote access) is added to the error message bu￿er with the message number of the original (local) error as a parameter.

For example:

No matching profile found in the AliasDB file. (DBERR 27002)

Local database connection failed with DBERR 3070. Remote access attempted. (DBWARN 29007)

Using ALLBASE/SQL Through ALLBASE/NET 3-5