HP 3000 Manuals HP 3000 Manuals
Getting Acquainted with ATCUtil
The following example shows how to use ATCUtil to attach a TurboIMAGE/XL
database to a DBEnvironment.
Invoking ATCUtil
To initiate an ATCUtil session, log on to a group and account containing
a TurboIMAGE/XL database and a DBEnvironment. At the MPE XL system
prompt type ATCUtil. For example:
__________________________________________________________________________________
| |
| :HELLO NANCY.ATC |
| :ATCUTIL |
| |
| |
| HP36385 A.00.00 ATC Utility WED, FEB 7, 1990, 11:13 AM|
| (C) COPYRIGHT HEWLETT-PACKARD COMPANY 1990 |
| |
| >> |
__________________________________________________________________________________
The DISPLAY OPTIONS command displays information about your ATCUTIL
session:
_____________________________________________
| |
| >>DISPLAY OPTIONS |
| Current TurboDB : |
| Current SQLDBE : |
| Echo : ON |
| Command Logging : ON |
| Log File : ATCLOG.SERED.ATC|
| >> |
_____________________________________________
Notice that the headings "Current TurboDB:" and "Current SQLDBE:" have no
information displayed at this time.
Attaching to a DBEnvironment
Three Turbo CONNECT commands are needed to attach a TurboIMAGE/XL
database to the DBEnvironment:
SET TURBODB identifies the TurboIMAGE/XL database to be attached to
a DBEnvironment. To issue this command you must be the
DBC or supply the TurboIMAGE/XL database maintenance
word.
SET SQLDBE identifies the DBEnvironment to which the TurboIMAGE/XL
database will be attached. To issue this command you
must be the DBECreator or supply the DBEnvironment
maintenance word.
ATTACH performs the attach. To issue this command you must be
a DBA of the DBEnvironment.
In the following example the SALES database and the PartsDBE
DBEnvironment are identified with two SET commands.
______________________________________
| |
| >>SET TURBODB SALES.SERED.ATC |
| >>SET SQLDBE PARTSDBE.SERED.ATC|
| >> |
| |
______________________________________
Once the SET commands are issued, the DISPLAY OPTIONS command displays
this information:
_______________________________________________
| |
| >>DISPLAY OPTIONS |
| Current TurboDB : SALES.SERED.ATC |
| Current SQLDBE : PARTSDBE.SERED.ATC|
| Echo : ON |
| Command Logging : ON |
| Log File : ATCLOG.SERED.ATC |
| >> |
_______________________________________________
The ATTACH command can now be used to attach SALES to PartsDBE. Note that
messages issued at attach time inform you if mapping is taking place.
______________________________________________________________________
| |
| >>ATTACH |
| Split 1 compound source field(s) (ATCWARN 32063). |
| Mapped 15 source table/source field name(s) (ATCWARN 32062). |
| Mapped 1 incompatible/imprecise source type(s) (ATCWARN 32061).|
| >> |
| >>EXIT |
| >> |
______________________________________________________________________
Selecting TurboIMAGE/XL Data from Mapped Tables
The attached TurboIMAGE/XL database is now a part of the DBEnvironment
and can be queried with ALLBASE/SQL SELECT statements by the DBC. (Other
users must be explicitly added by the DBC. Refer to chapter 2 for more
details.)
For example, here ALLBASE/ISQL is used to connect to PartsDBE. A SELECT
statement is then used to display the data in the mapped table,
SALES.VENDOR:
____________________________________________________________________________
| |
| isql=> CONNECT to 'PartsDBE'; |
| isql=> SELECT * from sales.vendor; |
| |
| select * from sales.vendor; |
| ----------------+--------------------------+------------+-----+------|
| VENDOR |STREET |CITY |STATE|ZIP |
| ----------------+--------------------------+------------+-----+------|
| Celtic Graphics |105 19th Ave. |Seattle |WA |98115 |
| Trident 3D |55 Homestead Road |Cupertino |CA |95014 |
| Ablrn Tech. |90 Marina Way |Berkeley |CA |94708 |
| Space Ent. |110 Homestead Ave. |Cupertino |CA |95014 |
| Cutler Micro |9442 E. 57th Ave. |Seattle |WA |98115 |
| Seminational Co.|5000 Marina Way |San Diego |CA |92093 |
| . . . . . |
| . . . . . |
| . . . . . |
| |
____________________________________________________________________________
This chapter has shown you how easy it is to get started using Turbo
CONNECT. Once the database is attached, you may need to complete several
additional ATCUtil tasks. Chapter 2 describes typical ATCUtil tasks and
shows you how to perform them.