HP 3000 Manuals

HP IMAGE/SQL Administration Guide

Table of Contents

 HP IMAGE/SQL Administration Guide
   HP 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

   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
      Configuring a DBEnvironment: Task 1
          Getting Ready
          Performing the Task
          Task Reference
      Attaching a TurboIMAGE/XL Database: Task 2
          Getting Ready
          Performing the Task
          Task Reference
      Adding IMAGE/SQL Users: Task 3
          Getting Ready
          Performing the Task
          Task Reference
      Updating IMAGE/SQL Utility Data Type Mapping Information: Task 4
          Getting Ready
          Performing the Task
          Task Reference
      Splitting Mapped Columns: Task 5
          Getting Ready
          Performing the Task
          Task Reference
      Updating Information about IMAGE/SQL Users: Task 6
          Getting Ready
          Performing the Task
          Task Reference
      Deleting IMAGE/SQL Users: Task 7
          Getting Ready
          Performing the Task
          Task Reference
      Detaching a TurboIMAGE/XL Database: Task 8
          Getting Ready
          Performing the Task
          Task Reference
      Displaying IMAGE/SQL Utility Information: Task 9
          Getting Ready
          Performing the Task
          Example 1: Displaying Database Information
          Example 2: Displaying Database Mapping Information
      Issuing MPE XL Commands from the IMAGE/SQL Utility: Task 10
          Performing the Task
      Setting IMAGE/SQL File Equations: Task 11
          Performing the Task
          Setting a File Equation for ATCINFO
          Setting a File Equation for ATCLOG
          Task Reference
             ATCINFO Reference
             ATCLOG Reference
      Logging IMAGE/SQL Utility Commands: Task 12
          Performing the Task
          Task Reference
      Using IMAGE/SQL Utility Command Files: Task 13
          Getting Ready
          Performing the Task
          Task Reference
      Selecting TurboIMAGE/XL Data with SQL:Task 14
          Getting Ready
          Performing the Task
          Task Reference
      Maintaining the ATCINFO File:Task 15
          Getting Ready
          Performing the Task
          Task Reference

   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
          Performance Considerations
             Up-to-Date Information
             Search Items in Queries

   Ch 4.  IMAGE/SQL Utility Command Syntax
       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
       Error Messages
          IMAGE/SQL Warning Messages
          File System Error Messages
      Error Messages (continued)
          DBCORE Errors
          Preprocessor Errors
          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
   GLOSSARY
   INDEX
       Index

MPE/iX 5.0 Documentation