HP 3000 Manuals HP 3000 Manuals
900 Series HP 3000 Computer Systems HP IMAGE/SQL Administration Guide Printed in U.S.A. Edition Third Edition E0693 Customer Order Number 36385-90001
________________________________________________________________________ |The information contained in this document is subject to change | |without notice. | | | |HEWLETT-PACKARD MAKES NO WARRANTY OF ANY KIND WITH REGARD TO THIS | |MATERIAL, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF | |MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. Hewlett-Packard | |shall not be liable for errors contained herein or use of this | |material. | | | |Hewlett-Packard assumes no responsibility for the use or reliability | |of its software on equipment that is not furnished by Hewlett-Packard.| | | |This document contains proprietary information which is protected by | |copyright. All rights are reserved. No part of this document may be | |photocopied, reproduced, or translated to another language without the| |prior written consent of Hewlett-Packard Company. | ________________________________________________________________________ Copyright (c)1990, 1992, 1993 by Hewlett-Packard Company Printed June 1993 Print History The following table lists the printings of this document, together with the respective release dates for each edition. The software version indicates the version of the software product at the time this document was issued. Many product releases do not require changes to the document. Therefore, do not expect a one-to-one correspondence between product releases and document editions. Edition Date Software Version --------------------------------------------------------------------------------------- First Edition July 1990 36385-A.00.00 Second Edition November 1992 36385-A.00.07 or 36385-B.F0.00[REV BEG] Third Edition June 1993 36385-B.F0.20[REV END] About this Manual This manual explains how to administer and maintain IMAGE/SQL. You should be familiar with TurboIMAGE/XL and have a general knowledge of relational databases to use this guide effectively.[REV BEG] This manual assumes you are familiar with IMAGE/SQL or have read Getting Started with HP IMAGE/SQL.[REV END] For compatibility reasons, this guide uses the acronym ATC (for ALLBASE/Turbo CONNECT). The terms Turbo CONNECT and ALLBASE/Turbo CONNECT are synonymous with IMAGE/SQL. [REV BEG] Change bars in this margin show where substantial changes have been made to this manual since the last edition.[REV END] The following briefly describes each chapter: [REV BEG] Chapter 1 Introduction Introduces some basic IMAGE/SQL concepts and shows you how to begin using IMAGE/SQL. Chapter 2 Using the IMAGE/SQL Utility Provides step-by-step directions for several typical administrative tasks. Chapter 3 Understanding IMAGE/SQL Provides a discussions of IMAGE/SQL concepts and functionality. Chapter 4 IMAGE/SQL Utility Command Syntax Contains detailed information about the IMAGE/SQL utility commands. Chapter 5 IMAGE/SQL Locking Describes how IMAGE/SQL assigns locks on IMAGE/SQL tables and how IMAGE/SQL handles deadlocks. Chapter 6 IMAGE/SQL Transactions Describes IMAGE/SQL transactions, repeatable reads, and IMAGE/SQL aborted transactions. Continued on the next page.[REV END] About this Manual (Continued) [REV BEG] Appendix A IMAGE/SQL Error Messages Contains reference information about error messages. Appendix B SALES Database Schema Contains a listing of the SALES database used throughout the manual. Appendix C IMAGE/SQL and Database Utilities Describes the DBUTIL, SQLUtil, and SQLGEN utilities. Appendix D SQL Exceptions Lists SQL statements that have restrictions when used on a TurboIMAGE/XL data set. Glossary Glossary Gives basic definitions of terms. [REV END] Suggested Tools for Accessing TurboIMAGE/XL Data For IMAGE/SQL users with a limited amount of ALLBASE/SQL experience, a high-level query and reporting tool like ALLBASE/Query provides easy access to TurboIMAGE/XL data from ALLBASE/SQL. For IMAGE/SQL users with more ALLBASE/SQL experience or for those who want to learn more about ALLBASE/SQL, ISQL can be used. Additional Documentation Here is a list of manuals you may find useful: Title Part Number[REV BEG] --------------------------------------------------------------------------------------- Getting Started with HP IMAGE/SQL 36385-90008[REV END] TurboIMAGE/XL Database Management System Reference 30391-90001 Manual ALLBASE/SQL Reference Manual 36216-90001 ALLBASE/ISQL Reference Manual 36216-90004 ALLBASE/SQL Database Administration Guide 36216-90005 ALLBASE/SQL C Application Programming Guide 36216-90023 ALLBASE/SQL COBOL Application Programming Guide 36216-90006 ALLBASE/SQL FORTRAN Application Programming Guide 36216-90030 ALLBASE/SQL Pascal Application Programming Guide 36216-90007 ALLBASE/SQL Message Manual 36216-90009 ALLBASE/SQL Quick Reference Guide 36216-90038 ALLBASE/NET User's Guide 36216-90031 Conventions UPPERCASE In a syntax statement, commands and keywords are shown in uppercase characters. The characters must be entered in the order shown; however, you can enter the characters in either uppercase or lowercase. For example: COMMAND can be entered as any of the following: command Command COMMAND italics In a syntax statement or an example, a word in italics represents a parameter or argument that you must replace with the actual value. In the following example, you must replace FileName with the name of the file: COMMAND FileName punctuation In a syntax statement, punctuation characters (other than brackets, braces, vertical bars, and ellipses) must be entered exactly as shown. In the following example, the parentheses and colon must be entered: (FileName):(FileName) underlining Within an example that contains interactive dialog, user input and user responses to prompts are indicated by underlining. In the following example, yes is the user's response to the prompt: Do you want to continue? >> yes { } In a syntax statement, braces enclose required elements. When several elements are stacked within braces, you must select one. In the following example, you must select either ON or OFF: COMMAND {ON } {OFF} [ ] In a syntax statement, brackets enclose optional elements. In the following example, OPTION can be omitted: COMMAND FileName [OPTION] When several elements are stacked within brackets, you can select one or none of the elements. In the following example, you can select OPTION or Parameter or neither. The elements cannot be repeated. COMMAND FileName [OPTION ] [Parameter] Conventions (continued) [...] In a syntax statement, horizontal ellipses enclosed in brackets indicate that you can repeatedly select the element(s) that appear within the immediately preceding pair of brackets or braces. In the example below, you can select Parameter zero or more times. Each instance of Parameter must be preceded by a comma: [,Parameter][...] In the example below, you only use the comma as a delimiter if Parameter is repeated; no comma is used before the first occurrence of Parameter: [Parameter][,...] |...| In a syntax statement, horizontal ellipses enclosed in vertical bars indicate that you can select more than one element within the immediately preceding pair of brackets or braces. However, each particular element can only be selected once. In the following example, you must select A, AB, BA, or B. The elements cannot be repeated. {A} |...| {B} ... In an example, horizontal or vertical ellipses indicate where portions of an example have been omitted. In a syntax statement, the space symbol shows a required blank. In the following example, Parameter and Parameter must be separated with a blank: (Parameter) (Parameter) The symbol indicates a key on the keyboard. For example, RETURN represents the carriage return key. CTRLchar CTRLchar indicates a control character. For example, CTRLY means that you press the control key and the Y key simultaneously.