HP 3000 Manuals HP 3000 Manuals
900 Series HP 3000 Computer Systems Getting Started with HP IMAGE/SQL Printed in U.S.A. Edition Second Edition E1294 Customer Order Number 36385-90008
Company or product names followed by (R) are U.S. registered trademarks of the respective company. Company or product names followed by TM are registered trademarks of the respective company. Forest & TreesTM is a registered trademark of Trinzic, Incorporated. Microsoft WindowsTM and Microsoft(R) are U.S. registered trademarks of Microsoft Corporation. PowerBuilderTM is a registered trademark of Powersoft Corporation. ________________________________________________________________________ |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 for incidental or | |consequential damages in connection with the furnishing, performance, | |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) 1993, 1994 by Hewlett-Packard Company Printed December 1994 Printing 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 June 1993 36385-B.F0.20 Second Edition December 1994 36385-B.G0.03 Preface This book describes how to start using HP IMAGE/SQL. HP IMAGE/SQL is offered on HP 3000 computers using the MPE/iX operating system. MPE/iX, Multiprogramming Executive with Integrated POSIX, is the latest in a series of forward-compatible operating systems for the HP 3000 line of computers. MPE/iX is a superset of MPE XL. All programs written for MPE XL will run without change under MPE/iX.
NOTE Hereafter in this manual, HP IMAGE/SQL will be referred to as IMAGE/SQL.
The following briefly describes each chapter in this manual: Chapter 1 Introducing IMAGE/SQL Introduces IMAGE/SQL. Chapter 2 Basic Concepts Presents basic ideas, tasks, and concepts. Chapter 3 Moving From TurboIMAGE/XL to IMAGE/SQL For the user coming from the world of TurboIMAGE/XL to IMAGE/SQL, describes comparative terminology and discusses steps to using IMAGE/SQL. Chapter 4 A Database Example Presents a simple database example. Chapter 5 IMAGE/SQL Tasks Shows these IMAGE/SQL tasks: setting up a database with ISQL, configuring a DBEnvironment, attaching a database, detaching a database, restructuring a database, and restoring an IMAGE/SQL environment. Chapter 6 Practicing with IMAGE/SQL Using MusicDBE Details the steps for creating a TurboIMAGE/XL database and setting up MusicDBE, the IMAGE/SQL sample DBEnvironment. Appendix A Tools For IMAGE/SQL Lists a selection of available tools. Glossary Glossary of IMAGE/SQL Terms Gives basic definitions of terms. Additional Documentation Refer to the listed manuals for additional information: * HP IMAGE/SQL Administration Guide (36385-90001) This guide explains how to administer and maintain IMAGE/SQL. For this manual, you should be familiar with and have a general knowledge of relational databases. * TurboIMAGE/XL Database Management System Reference Manual (30391-90001) This manual describes the TurboIMAGE/XL Database Management System for the HP 3000 Series 900 computer. It is the reference document for anyone designing, creating, and maintaining a database and for application programmers writing database access programs. * ISQL Reference Manual for ALLBASE/SQL and IMAGE/SQL (36216-90096) This manual describes ISQL (Interactive Structured Query Language) and how to use it. * ALLBASE/NET User's Guide (36216-90031) This guide describes ALLBASE/NET, a product that allows an application on MPE/iX to access an ALLBASE/SQL DBEnvironment on another MPE/iX system. This guide is written for the system administrator, programmers, and users of ALLBASE/SQL DBEnvironments. * ALLBASE/SQL Database Administration Guide (36216-90005) This manual describes how to design, create, and maintain ALLBASE/SQL databases on HP 3000 computers. This guide is written for experienced users of SQL and SQL application programmers. * ALLBASE/SQL Message Manual (36216-90009) This manual explains the causes and actions to be taken for warning and error conditions that occur using the following components of ALLBASE/SQL: SQL, ISQL, SQLAudit, SQLGEN, SQLUtil, the preprocessors, SQLMigrate, NET, or NETUtil. This manual is for database administrators, application programmers, and others who are using ALLBASE/SQL. This manual assumes that the user has a basic understanding of databases and ALLBASE/SQL concepts. * ALLBASE/SQL Performance and Monitoring Guidelines (36216-90102) This is a technical manual for database administrators to assist in monitoring the performance of ALLBASE/SQL applications. * ALLBASE/SQL Reference Manual (36216-90001) This manual presents the syntax and semantics of SQL on HP 3000 computers. This manual contains basic information about ALLBASE/SQL, as well as in-depth information about ALLBASE/SQL data types and statements. The first three chapters are for all readers, including new users of ALLBASE/SQL. The remaining chapters are for experienced SQL users and SQL application programmers. * HP PC API User's Guide for ALLBASE/SQL and IMAGE/SQL (36216-90104) This guide describes HP PC API for ALLBASE/SQL and IMAGE/SQL, how to install it, and how to maintain it. This guide is for the system administrator installing HP PC API for ALLBASE/SQL and IMAGE/SQL and for someone using application software on the PC client. * Up and Running with ALLBASE/SQL (36389-90011) This is a getting started reference for ALLBASE/SQL. 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 an example, horizontal or vertical ellipses indicate where portions of an example have been omitted. Conventions (continued) [ ] 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] [...] 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} 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.