HPlogo

Getting Started with HP IMAGE/SQL: HP 3000 MPE/ iX Computer Systems
» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Glossary

 » Index

spacerspacerspacer
spacer
spacer
   
 

HP Part Number: 36385-90011

Edition: Edition 2

Published: Printed in: U.S.A. December 1994

Table of Contents

Preface
Additional Documentation
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?
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?
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
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
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
Logging IMAGE/SQL Utility Commands
Using IMAGE/SQL Utility Command Files
Accessing TurboIMAGE/XL Data with ISQL
Maintaining the ATCINFO File
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
Selecting Data
Modifying Data
Deleting Data
Conclusion
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

List of Figures

1-1 Overview of IMAGE/SQL
2-1 Relational Operations
2-2 Structure of a DBEnvironment
3-1 TurboIMAGE/XL Architecture
3-2 IMAGE/SQL Architecture
4-1 Database Design
5-1 IMAGE/SQL Utility Command Prerequisites
5-2 ISQL Banner
6-1 SQLSetup Menu
6-2 Information on Tables and Views
6-3 Column Definitions of a Table
6-4 Groups in the System Catalog
6-5 Changes to Levels of Security
6-6 UserID Information
6-7 INSERT Command Display
6-8 Result of the EXTERNAL Option
6-9 Result of the INTERNAL Option
6-10 JOINED List
6-11 Result of the Query
6-12 Result of Modifying Data

List of Tables

2-1 Employee Accounts
2-2 Table 1. Employees Table
2-3 Table 2. Telephone Table
2-4 Table 3. Accounts Table
3-1 Comparing IMAGE/SQL and TurboIMAGE/XL Concepts
3-2 Mapping of TurboIMAGE/XL and IMAGE/SQL Data Types
4-1 Attributes for Four Entities
4-2 Columns and Keys for Four Tables
6-1 Menu Options
A-1 Categories of Tools
   


Preface  
Feedback to webmaster