HP 3000 Manuals HP 3000 Manuals
Database Environments HP ALLBASE/4GL can access HP ALLBASE/SQL database environments anywhere in the host file system. The name and location of a database is determined by the name and location of the DBECon file for the database. The database for an application is specified on the application definition screen in the HP ALLBASE/4GL administrator. The application definition screen in the HP ALLBASE/4GL administrator also allows the administrator to specify the name of the SQL owner group for the application. HP ALLBASE/4GL transfers ownership of all tables created from HP ALLBASE/4GL to this owner group. HP ALLBASE/4GL also transfers ownership of the module for an application or version to this owner group. The database environment for an application must exist, and must contain at least one DBEfileset and at least one DBEfile before you can start developing the application. HP ALLBASE/4GL uses the MPE/iX variable HP4SQLPATH to determine the location of the database DBECon file. The HP4SQLPATH variable can specify an account name and a group name for the DBECon file. If the DBECon file name specified on the application definition screen is a fully qualified name (that is, a file name in the form FILE.GROUP.ACCOUNT), the HP4SQLPATH variable is ignored. If the DBECon file specification on the application definition screen does not include a group and account name, HP ALLBASE/4GL appends the current value of the HP4SQLPATH variable to the file name to determine the name and location of the database environment for the application. If HP4SQLPATH is not defined, HP ALLBASE/4GL expects to find the DBECon file in the user's current group and account. Multi-User Database Environments Databases used with HP ALLBASE/4GL should be configured as multi-user databases during application development. HP ALLBASE/4GL connects to the database environment when you generate an SQL logic block or create a table from HP ALLBASE/4GL. The connection is maintained for the remainder of the HP ALLBASE/4GL session. If you use the application testing option to run the application during development, HP ALLBASE/4GL attempts to connect to the database environment a second time. This causes an error condition if the database environment is configured as a single user database. In the HP ALLBASE/4GL run-time environment, database environments can be configured for single user operation if required.