
3
Using ALLBASE/SQL Through ALLBASE/NET
After the AliasDB and NETUsers les ha ve been created and con tain valid proles 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 specied 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 specied 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