Chapter 2 Using the IMAGE/SQL Utility

Table of Contents

Administering IMAGE/SQL:An Overview

Setting Up the IMAGE/SQL Environment

Maintaining the IMAGE/SQL Environment

About the Tasks

Tasks Covered in this Chapter

Task 1: Configuring a DBEnvironment

Task 2: Attaching a TurboIMAGE/XL Database

Task 3: Adding IMAGE/SQL Users

Task 4: Updating IMAGE/SQL Utility Data Type Mapping Information

Task 5: Splitting Mapped Columns

Task 6: Updating Information about IMAGE/SQL Users

Task 7: Deleting IMAGE/SQL Users

Task 8: Adding a Log File

Task 9: Detaching a TurboIMAGE/XL Database

Task 10: Displaying IMAGE/SQL Utility Information

Example 1: Displaying Database Information

Example 2: Displaying Database Mapping Information

Task 11: Issuing MPE/iX Commands from the IMAGE/SQL Utility

Task 12: Setting IMAGE/SQL Utility File Equations

Setting a File Equation for ATCINFO

Setting a File Equation for ATCLOG

Task 13: Logging IMAGE/SQL Utility Commands

Task 14: Using IMAGE/SQL Utility Command Files

Task 15: Selecting TurboIMAGE/XL Data with SQL

Task 16: Maintaining the ATCINFO File

• An overview of the role of the IMAGE/SQL administrator.

• Checklists showing which tasks to perform when setting up and maintaining the IMAGE/SQL environment.

• An explanation of how each task description is organized.

• A table showing the prerequisites needed for performing IMAGE/SQL utility tasks.

• A summary of commands needed for each task.

• Directions for performing each task.