Tasks Covered in this Chapter

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

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 mapping information	Task 4	UPDATE TYPE
Splitting mapped columns	Task 5	SPLIT
Updating information about IMAGE/SQL users	Task 6	UPDATE USER
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 information	Task 10	DISPLAY OPTIONS DISPLAY MAP DISPLAY USER DISPLAY SQLDBE DISPLAY TURBODB HELP
Issuing MPE/iX commands from the IMAGE/SQL utility	Task 11	:`MPE/iXCommandName`
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

Tasks Covered in this Chapter

Technical documentation

» Table of Contents

» Glossary

» Index