HP 3000 Manuals HP 3000 Manuals
Tasks Covered in this Chapter
For your convenience Table 2-4 lists the tasks and the commands
needed to perform each task.
Table 2-4. IMAGE/SQL Utility Tasks and Related Commands
-----------------------------------------------------------------------------------------------
| | | |
| Task | Task # | Commands Used |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| Configuring a DBEnvironment | Task 1 | START DBE NEW (an SQL statement) |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| Attaching a TurboIMAGE/XL database | Task 2 | SET SQLDBE |
| | | SET TURBODB |
| | | ATTACH |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| Adding IMAGE/SQL users | Task 3 | ADD USER |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| Updating data type mapping | Task 4 | UPDATE TYPE |
| information | | |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| Splitting data items | Task 5 | SPLIT |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| Updating information about | Task 6 | UPDATE USER |
| IMAGE/SQL users | | |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| Deleting IMAGE/SQL users | Task 7 | DELETE USER |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| Detaching a TurboIMAGE/XL database | Task 8 | DETACH |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| Displaying IMAGE/SQL utility | Task 9 | DISPLAY OPTIONS |
| information | | DISPLAY MAP |
| | | DISPLAY USER |
| | | DISPLAY SQLDBE |
| | | DISPLAY TURBODB |
| | | HELP |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| Issuing MPE XL commands | Task 10 | :MPE XLCommandName |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| Setting IMAGE/SQL utility file | Task 11 | :FILE |
| equations | | |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| Logging IMAGE/SQL utility commands | Task 12 | LOG |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| Using IMAGE/SQL utility command | Task 13 | XEQ |
| files | | |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| Selecting data from mapped tables | Task 14 | SELECT (an SQL statement) |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| Maintaining the ATCINFO file | Task 15 | RECOVER |
| | | |
-----------------------------------------------------------------------------------------------