HP 3000 Manuals

IMAGE/SQL Administration Guide

Table of Contents

 IMAGE/SQL Administration Guide
   IMAGE/SQL Administration Guide : COPYRIGHT NOTICE

   Ch 1.  Introduction
      What is IMAGE/SQL?
      Basic Terms for Getting Started
      Getting Acquainted with the IMAGE/SQL Utility
          Invoking the IMAGE/SQL Utility
          Attaching to a DBEnvironment
          Selecting TurboIMAGE/XL Data from Mapped Tables
          Migrating a DBEnvironment

   Ch 2.  Using the IMAGE/SQL Utility
      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 File Equations
          Setting a File Equation for ATCINFO
          Setting a File Equation for ATCLOG
             ATCINFO Reference
             ATCLOG Reference
      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

   Ch 3.  Understanding IMAGE/SQL
      How IMAGE/SQL Works
          IMAGE/SQL Files
          What Takes Place During an Attach?
          What Takes Place During a Detach?
      About IMAGE/SQL Security
          Controlling IMAGE/SQL User Access
          IMAGE/SQL Data Type Mapping
          At Run Time
      Accessing Mapped Tables
          Up-to-Date Information
          Search Items in Queries

   Ch 4.  IMAGE/SQL Utility Commands
      ADD USER
      ATTACH
      DELETE USER
      DETACH
      DISPLAY MAP
      DISPLAY OPTIONS
      DISPLAY SQLDBES
      DISPLAY TURBODBS
      DISPLAY USERS
      ECHO
      EXIT
      HELP
      LOG
      QUIT
      RECOVER
      REDO
      SET SQLDBE
      SET TURBODB
      SPLIT
      UPDATE TYPE
      UPDATE USER
      XEQ

   Ch 5.  IMAGE/SQL Locking
      Lock Assignment
      IMAGE/SQL Deadlocks

   Ch 6.  IMAGE/SQL Transactions
      Definition
      Repeatable Read
      Restrictions
      IMAGE/SQL Aborted Transaction

   Ap A. IMAGE/SQL Error Messages
       IMAGE/SQL Error Messages
          IMAGE/SQL Warning Messages
      IMAGE/SQL Error Messages (contd)
          File System Error Messages
          DBCORE Errors
          Preprocessor Errors
      IMAGE/SQL Error Messages (contd.)
          General Errors

   Ap B. SALES Database Schema

   Ap C. IMAGE/SQL and Database Utilities
       DBUTIL
          Displaying Information
          Purging an Attached Database
      SQLUtil
      SQLGEN

   Ap D. SQL Exceptions
      SQL Statements with Exceptions
          ALTER TABLE
          BEGIN ARCHIVE
          BEGIN WORK
          CHECKPOINT
          COMMIT ARCHIVE
          COMMIT WORK
          CREATE INDEX
          CREATE SCHEMA
          CREATE TABLE
          DECLARE CURSOR
          DELETE
          DELETE WHERE CURRENT
          DROP DBEFILE
          DROP TABLE
          DROP VIEW
          INSERT
          LOCK TABLE
          OPEN
          REVOKE
          ROLLBACK WORK
          SAVEPOINTS
          SELECT
          SET CONSTRAINTS
          SET DML ATOMICITY
          START DBE NEW
          TRANSFER OWNERSHIP
          UPDATE
          UPDATE WHERE CURRENT
      SQL Statements without Exceptions

   Ap E. Using SQLMigrate
      Running SQLMigrate
          Forward Migration
             Steps for Forward Migration
          JCWs Set by SQLMigrate
          Backwards Migration
          Steps for Backwards Migration
   GLOSSARY
   INDEX
       Index

MPE/iX 5.0 Documentation