3

Using ALLBASE/SQL Through ALLBASE/NET

After the AliasDB and NETUsers ￿les ha ve been created and con tain valid pro￿les and the Listener is running on the serv er, an application can transparen tly access a remote ALLBASE/SQL DBEnvironment through ALLBASE/NET.

You can use ALLBASE/NET with man y applications. Some of them are discussed in this chapter:

ALLBASE/ISQL

ALLBASE/SQL preprocessors

User-written application programs

ALLBASE/Query (HP Visor)

ALLBASE/4GL

Information Access

PC-based Application Soft ware

When accessing a remote DBEn vironment, the user on the clien t node must be in the group and account speci￿ed in the NETUsers ￿le.

Using ALLBASE/ISQL

To use ISQL to access a remote DBEn vironment, do the following:

1.Invoke ISQL on the client by typing:

:isql

2.Initiate a DBE session b y typing: isql=> connect to `AliasName';

AliasName references a particular DBEn vironment on the server. The alias name is speci￿ed in the AliasDB ￿le on the clien t. The ISQL commands that are issued after this connect statement act on the remote DBEn vironment. However, be aware that if y ou execute the ISQL STORE command on a remote DBEn vironment, the ￿le is written to the clien t.

You must have Version A.12.00 or later of ISQL to use an alias name.

Note

ALLBASE/NET does not allo w the use of the START DBE NEWLOG or

 

START DBE NEW commands remotely .

 

 

Using ALLBASE/SQL Through ALLBASE/NET 3-1