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 IMAGE/SQL utility data type | Task 4 | UPDATE TYPE |
| mapping information | | |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| Splitting mapped columns | Task 5 | SPLIT |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| Updating information about IMAGE/SQL | Task 6 | UPDATE USER |
| users | | |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| Deleting IMAGE/SQL users | Task 7 | DELETE USER |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| Creating a log file | Task 8 | ADDLOG (an SQLUtil statement) |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| Detaching a TurboIMAGE/XL database | Task 9 | DETACH |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| Displaying IMAGE/SQL utility | Task 10 | DISPLAY OPTIONS |
| information | | DISPLAY MAP |
| | | DISPLAY USER |
| | | DISPLAY SQLDBE |
| | | DISPLAY TURBODB |
| | | HELP |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| Issuing MPE/iX commands from the | Task 11 | :MPE/iXCommandName |
| IMAGE/SQL utility | | |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| Setting IMAGE/SQL file equations | Task 12 | :FILE |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| Logging IMAGE/SQL utility commands | Task 13 | LOG |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| Using IMAGE/SQL utility command files | Task 14 | XEQ |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| Selecting TurboIMAGE/XL data with SQL | Task 15 | SELECT (an SQL statement) |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| Maintaining the ATCINFO file | Task 16 | RECOVER |
| | | |
-----------------------------------------------------------------------------------------------