HP 3000 Manuals

Getting Started with HP IMAGE/SQL

Table of Contents

 Getting Started with HP IMAGE/SQL
   Getting Started with HP IMAGE/SQL : COPYRIGHT NOTICE

   Ch 1.  Introducing IMAGE/SQL
      What Is IMAGE/SQL?
      What Are the Components of IMAGE/SQL?
          TurboIMAGE/XL
          ALLBASE/SQL
          HP PC API for ALLBASE/SQL and IMAGE/SQL
          ALLBASE/NET
          IMAGE/SQL Utility
          ISQL
          SQLGEN
          SQLUtil
          Preprocessors
      What Are The Benefits of Using IMAGE/SQL?
      How Do IMAGE/SQL and ALLBASE/SQL Coexist?

   Ch 2.  Basic Concepts
      What Is a Database?
      What Is a Relational Database?
          Rows and Columns
          Sample Database Table
          Using Several Tables
      What Is SQL?
      What Is TurboIMAGE/XL?
      What Is a DBEnvironment?
          The DBECon file
          DBEFiles
          DBEFileSets
          Databases
          Tables
          System Catalog
          Log Files
      How Do I Create a DBEnvironment?
      How Do I Create a Database?
      How Do I Access a Database through SQL?
      How Do I Control Database Access?

   Ch 3.  Moving from TurboIMAGE/XL to IMAGE/SQL
      Basic Structures
      Creating Databases
          Root File versus DBECon File and System Catalog
          Naming Conventions
      Tables versus Data Sets
      Mapping of Data Types
          Basic Mapping
          Compound Items
          Default Values
      Defining Security
          TurboIMAGE/XL Security
          Granting and Revoking IMAGE/SQL Authorities
          Defining IMAGE/SQL Groups
          Defining Views in IMAGE/SQL
      Methods of Accessing Databases
          Interactive Access
          Programmatic Access
          Locking Mechanisms

   Ch 4.  A Database Example
      Understanding the Environment
      The Example Application
      Logical Data Entities
      Identifying Relationships Between Entities
      Defining the Data Sets
      Defining the Security Scheme
      Defining the TurboIMAGE/XL Database
      Creating the TurboIMAGE/XL Database

   Ch 5.  IMAGE/SQL Tasks
      About the Tasks
      Setting Up a Database with ISQL
          Running ISQL
          Creating a DBEnvironment
      Configuring a DBEnvironment
          Listing the Newly Created Files
      Attaching a TurboIMAGE/XL Database
      Detaching a TurboIMAGE/XL Database
      Displaying IMAGE/SQL Utility Information
          Example 1: Displaying Database Information
          Example 2: Displaying Database Mapping Information
          Example 3: Displaying DBEnvironment Information
          Example 4: Displaying User Information
      Issuing MPE/iX Commands from the IMAGE/SQL Utility
      Setting IMAGE/SQL File Equations
          Setting a File Equation for ATCINFO
          Setting a File Equation for ATCLOG
             ATCINFO Reference
             ATCLOG Reference
      Logging IMAGE/SQL Utility Commands
      Using IMAGE/SQL Utility Command Files
      Accessing TurboIMAGE/XL Data with ISQL
      Maintaining the ATCINFO File

   Ch 6.  Practicing with IMAGE/SQL Using MusicDBE
      Setting Up MUSIC and MusicDBE
      Examining The Database
          Examining Table Descriptions
          Examining the Authority Structure
      Adding Data to the Database
          Using the INSERT Statement
          Using the LOAD Command
             The EXTERNAL Option
             The INTERNAL Option
      Selecting Data
      Modifying Data
      Deleting Data
      Conclusion

   Ap A. Tools For IMAGE/SQL
      Decision Support Tools
      Executive Information System (EIS) Tools
      Application Development Tools on the PC
      Application Development Tools on the Server
   GLOSSARY
   INDEX
       Index

MPE/iX 5.0 Documentation