Using the Preprocessor

To develop and run an application program from the clien t, the client must have the following software:

ALLBASE/NET utilit y program ￿le (NETUtil)

ALLBASE/SQL software

The server must have the following softw are: The Listener

ALLBASE/NET utilit y program ￿le (NETUtil)

ALLBASE/SQL software

To use the preprocessor, do the following steps:

1. In the source code, de￿ne the DBEn vironment on the server with the alias name:

begin

.

.

.

EXEC SQL CONNECT TO `AliasName';

.

.

.

EXEC SQL RELEASE; end.

You can specify an alias name dynamically b y using a host variable.

For example:

EXEC SQL BEGIN DECLARE SECTION;

AliasName: packed array [1..128] of char;

.

.

.

EXEC SQL END DECLARE SECTION;

EXEC SQL CONNECT TO AliasName;

3-2 Using ALLBASE/SQL Through ALLBASE/NET