HP 3000 Manuals HP 3000 Manuals
TurboIMAGE/XL Database Management System DBChange Plus User's Guide HP Part No. 36386-90001 Printed in U.S.A. Edition First Edition E1290
________________________________________________________________________ |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)1987, 1988, 1989, 1990 by Hewlett-Packard Company Printed 19900101 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 December 1990 36386-A.00.00 Preface Because DBChange Plus is designed to be used primarily by database creators, this guide is written for a user with both a thorough knowledge of the HP 3000 and the TurboIMAGE/XL database management system. How to Use This Guide... This guide has two purposes: * If you are a new DBChange Plus user, this guide is designed to acquaint you with DBChange Plus and to help you learn to use DBChange Plus successfully. * Once you are an experienced DBChange Plus user, this guide provides quick access to information about DBChange Plus commands. The format of this guide reflects this dual purpose. Whether you are a new or experienced DBChange Plus user, you need to understand this two-part format to make effective use of the guide. The guide contains the following information: * Task Reference--For new users, chapters 1 through 9 explain how to perform database restructuring tasks. Each chapter begins with an overview of the commands used for each task, followed by step-by-step instructions for each task. Each chapter uses examples to enhance the discussion of each task. * Command Reference--For experienced users, chapter 10 provides quick access to the DBChange Plus commands. You can use either the table of contents or the index to locate information. Here's what you'll find in this guide: Chapter 1. Introduction to DBChange Plus This chapter introduces you to DBChange Plus. Here you'll become familiar with some of the basic features of DBChange Plus, and you'll learn to do a few simple tasks. Chapter 2. Copying a Database This chapter describes how to copy a database. Chapter 3. Displaying Information about a Database This chapter describes how to print the schema for a TurboIMAGE/XL database. It also explains how to display information about the database structure. Chapter 4. Changing Data Items This chapter describes how to change data items in a TurboIMAGE/XL database. Chapter 5. Changing Data Sets This chapter describes how to change data sets in a TurboIMAGE/XL database. It describes the steps involved in changing data set fields and data set characteristics, such as capacity and blocking factor. This chapter also explains how to recover a data set. Chapter 6. Changing Paths in a Database This chapter describes how to make changes to paths in a TurboIMAGE/XL database. Chapter 7. Changing Database Security This chapter describes how to change user access to a TurboIMAGE/XL database. Chapter 8. Maintaining the Database This chapter describes how to maintain a TurboIMAGE/XL database. Checking for structural integrity, fixing structural problems, improving database performance, and managing database capacity are discussed. Chapter 9. Applying Changes to the Database Structure This chapter describes how to use the DBAPLUS program to actually restructure the database. Note that this chapter signals the end of the task reference portion of this guide. Chapter 10. DBChange Plus Commands This chapter is a quick reference for experienced DBChange Plus users. All the DBChange Plus commands are presented here in alphabetical order. The syntax and parameters are defined for each command, followed by a description and examples. Appendix A. DBChange Plus Messages This appendix lists the messages you may receive when using DBChange Plus. The meaning of each error and the action to take to correct problem are provided. Appendix B. ORDERS Schema This appendix shows the ORDERS database schema listing. The ORDERS database is the sample database used for examples throughout this guide. Index Other Information Sources Manuals In addition to this guide, you may need to consult the following manuals: Title Part Number --------------------------------------------------------------------------------------- MPE XL Intrinsics Reference Manual 32650-90028 TurboIMAGE/XL Database Management System Reference Manual 30391-90001 Training The following training courses are available: Title Course Number --------------------------------------------------------------------------------------- TurboIMAGE DBMS/3000 35053B Advanced TurboIMAGE 51480A 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. CTRL character CTRL character indicates a control character. For example, CTRLY means that you press the control key and the Y key simultaneously.