HPlogo

IMAGE/SQL Administration Guide: HP 3000 MPE/iX Computer Systems

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Glossary

 » Index

HP Part Number: 36385-90012

Edition: Fifth Edition

Published: Printed in: U.S.A. August 1997


Table of Contents

About this Manual
Migrating a DBEnvironment
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
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 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
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
4 IMAGE/SQL Utility Commands
ADD USER
Syntax
Parameters
Prerequisites
Description
Example
ATTACH
Syntax
Parameters
Prerequisites
Description
Example
DELETE USER
Syntax
Parameters
Prerequisites
Description
Example
DETACH
Syntax
Command Prerequisites
Description
Example
DISPLAY MAP
Syntax
Parameters
Prerequisites
Description
Example
DISPLAY OPTIONS
Syntax
Prerequisites
Description
Example
DISPLAY SQLDBES
Syntax
Parameters
Prerequisites
Description
Example
DISPLAY TURBODBS
Syntax
Parameters
Prerequisites
Description
Example
DISPLAY USERS
Syntax
Parameters
Prerequisites
Description
Example
ECHO
Syntax
Parameters
Prerequisites
Description
Example
EXIT
Syntax
Prerequisites
Description
Example
HELP
Syntax
Parameters
Prerequisites
Description
Example 1
Example 2
LOG
Syntax
Parameters
Prerequisites
Description
Example
QUIT
Syntax
Prerequisites
Description
Example
RECOVER
Syntax
Prerequisites
Description
Example
REDO
Syntax
Prerequisites
Description
Subcommands
Example
SET SQLDBE
Syntax
Parameters
Prerequisites
Description
Example
SET TURBODB
Syntax
Parameters
Prerequisites
Description
Example
SPLIT
Syntax
Parameters
Prerequisites
Description
Example
UPDATE TYPE
Syntax
Parameters
Prerequisites
Description
Example
UPDATE USER
Syntax
Parameters
Prerequisites
Description
Example
XEQ
Syntax
Parameters
Prerequisites
Description
Example
5 IMAGE/SQL Locking
Lock Assignment
IMAGE/SQL Deadlocks
6 IMAGE/SQL Transactions
Definition
Repeatable Read
Restrictions
IMAGE/SQL Aborted Transaction
A IMAGE/SQL Error Messages
Messages
IMAGE/SQL Warning Messages
File System Error Messages
DBCORE Errors
Preprocessor Errors
General Errors
B SALES Database Schema
C IMAGE/SQL and Database Utilities
DBUTIL
Displaying Information
Purging an Attached Database
Detaching an Attached Database
DBUTIL Enhancements for TPI
SQLUtil
SQLGEN
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
E SQL Views for Indices
Executing SQLINSTL and ODBCVIEW
Views for TurboIMAGE/XL
SYSTEM.IMAGEKEY and CATALOG.IMAGEKEY
SYSTEM.TPINDEX and CATALOG.TPINDEX
SYSTEM.INDEX and CATALOG.INDEX
F Date/Time API
Date/Time API Description
Updating K8 Data Types
Mapping of DATE/TIME Functions
DBTODATE
DBTOTIME
DBTODTTM
DBTOITVL
DBTOCHAR
DBTOINT
glossary
Index
Feedback to webmaster