HP 3000 Manuals HP 3000 Manuals
Getting Ready to Use the SELECT Command
To use the SELECT command, first do the following:
1. Run ISQL at the operating system prompt.
ALLBASE/SQL then displays the ISQL banner and prompt.
2. Connect to the DBEnvironment that contains the information you
want to retrieve.
__________________________________________________________________
| |
| :isql |
| |
| IIIIIIII SSSSSSSS QQQQQQQ LL |
| II SS QQ QQ LL |
| II SS QQ QQ LL |
| II SSSSSS QQ QQ LL |
| II SS QQ QQ LL |
| II SS QQ QQ LL |
| IIIIIIII SSSSSSS QQQQQQ QQ LLLLLLLLL|
| |
| |
| WED, SEP 20, 1989, |
| 1:16 PM |
| HP36216-02A.20.00 Interactive SQL/3000 HP |
| SQL/MPE XL |
| (C) COPYRIGHT HEWLETT-PACKARD CO. |
| 1982,1983,1984,1985,1986,1987,1988 |
| 1989. ALL RIGHTS RESERVED. |
| |
| isql=> CONNECT to `PartsDBE'; |
| isql=> |
__________________________________________________________________
You should make note of a few things before going further:
* To terminate a command in ISQL, you must always use a semicolon and
press Return.
* To leave ISQL, type exit followed by a semicolon:
isql=> exit; Return
Note, the following will not work:
isql=> exit Return
* To correct a command in ISQL, you can use the ISQL REDO command. It
works like the ATCUTIL REDO command, except there is no U subcommand.
If ISQL asks whether you want to commit work, reply either Y or N and
press Return. It doesn't matter which, because you are not changing the
database.