HPlogo IMAGE/SQL Administration Guide: HP 3000 MPE/iX Computer Systems > Chapter 2 Using the IMAGE/SQL Utility

Tasks Covered in this Chapter

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Glossary

 » Index

For your convenience Table 2-4 “IMAGE/SQL Utility Tasks and Related Commands” lists the tasks and the commands needed to perform each task. Most of the IMAGE/SQL commands require using SET SQLDBE and/or SET TURBODB before using the commands.

Table 2-4 IMAGE/SQL Utility Tasks and Related Commands

TaskTask #Commands Used
Configuring a DBEnvironmentTask 1START DBE NEW (an SQL statement)
Attaching a TurboIMAGE/XL databaseTask 2

SET SQLDBE SET TURBODB ATTACH

Adding IMAGE/SQL usersTask 3ADD USER
Updating IMAGE/SQL utility data type mapping informationTask 4UPDATE TYPE
Splitting mapped columnsTask 5SPLIT
Updating information about IMAGE/SQL usersTask 6UPDATE USER
Deleting IMAGE/SQL usersTask 7DELETE USER
Creating a log fileTask 8ADDLOG (an SQLUtil statement)
Detaching a TurboIMAGE/XL databaseTask 9DETACH
Displaying IMAGE/SQL utility informationTask 10

DISPLAY OPTIONS DISPLAY MAP DISPLAY USER DISPLAY SQLDBE DISPLAY TURBODB HELP

Issuing MPE/iX commands from the IMAGE/SQL utilityTask 11:MPE/iXCommandName
Setting IMAGE/SQL file equationsTask 12:FILE
Logging IMAGE/SQL utility commandsTask 13LOG
Using IMAGE/SQL utility command filesTask 14XEQ
Selecting TurboIMAGE/XL data with SQLTask 15SELECT (an SQL statement)
Maintaining the ATCINFO fileTask 16RECOVER

 

Feedback to webmaster