HP 3000 Manuals HP 3000 Manuals
Table of Contents
DBChange Plus User's Guide
DBChange Plus User's Guide : COPYRIGHT NOTICE
Ch 1. Introduction to DBChange Plus
What Is DBChange Plus?
DBChange Plus Operation
Getting Started
Running the DBCPLUS Program
Getting Help
Specifying the Database to be Restructured
How the Change File Works
Creating a New Change File
Updating an Existing Change File
Purging an Existing Change File
Using Some DBChange Plus Commands
Adding a Data Item
Changing a Password
Deleting a Field
Leaving the DBChange Program
Getting to Know the DBChange Plus Command Interface
Command Format
Difference Between Deferred and Immediate Commands
Command Sequence
Terminating a Command
Executing Commands from a File
Including Comments in a File
Using a Command File
Using a Job File
Issuing MPE XL Commands from within the DBCPLUS Program
Redirecting Input, Output, and the Schema Listing
Printing the Schema to an MPE XL File
Printing the Schema to an MPE XL File in Interactive Mode
Printing the Schema to an MPE XL File in Batch Mode
How DBChange Plus Handles Errors
How DBChange Plus Helps You Avoid and Recover from Errors
Using Job Control Words to Check the Status of DBChange Plus
Ch 3. Displaying Information about the Database
Summary of Commands to Display Information about the Database
Printing the Schema
Aborting the PRINT SCHEMA Command
Using REVIEW Commands to Display Information about the Database
Displaying User Classes and Passwords
Displaying Data Items
Displaying Information about Data Sets
Displaying Data Sets
Displaying Fields
Displaying Paths
Ch 4. Changing Data Items
Summary of Commands to Change Data Items
Helpful TurboIMAGE/XL Information
Item Type Conversions
Adding a Data Item
Deleting a Data Item
Recovering a Data Item
Reordering a Data Item
Renaming a Data Item
Changing a Data Item
Changing Data Item Attributes
Ch 5. Changing Data Sets
Summary of Commands to Change Data Sets
Helpful TurboIMAGE Information
Adding a Master Data Set
Adding a Detail Data Set
Deleting a Data Set
Recovering a Data Set
Reordering a Data Set
Renaming a Data Set
Changing the Capacity of a Data Set
Changing the Blocking Factor of a Data Set
Changing the Maximum Block Length of a Data Set
Changing the Device Class of a Data Set
Adding a Field to a Data Set
Deleting a Field from a Data Set
Reordering a Field in a Data Set
Adding a Sort Item to a Detail Data Set
Deleting a Sort Item from a Detail Data Set
Ch 6. Changing Paths in a Database
Summary of Commands to Change Paths
Helpful TurboIMAGE/XL Information
Adding a Path to a Detail Data Set
Redefining the Primary Path in a Detail Data Set
Deleting a Path from a Detail Data Set
Ch 7. Changing Database Security
Summary of Commands to Change Database Security
Helpful TurboIMAGE/XL Information
Adding a Password to the Database
Changing a Password in the Database
Deleting a Password from the Database
Changing Data Item Security
Deleting Data Item Security
Changing Data Set Security
Deleting Data Set Security
Ch 8. Maintaining the Database
Summary of Commands to Maintain the Database
Guidelines for Maintaining the Database
How the FIX Commands Operate
Repacking Data Sets
Checking and Fixing Paths
Checking Paths
Analyzing the CHECK PATH Statistics
Fixing Paths
Checking and Fixing Data Sets
Checking a Master Data Set
Analyzing the CHECK SET Statistics for a Master Data Set
Fixing a Master Data Set
Checking a Detail Data Set
Analyzing the CHECK SET Statistics for a Detail Data Set
Fixing a Detail Data Set
Checking and Fixing the Entire Database
Using the QUICK Option with CHECK Commands
Ch 9. Applying Changes to the Database Structure
What is DBAPLUS?
Before Restructuring the Database
Saving the New Schema
Saving the Schema Processor Output
Methods of Using the DBAPLUS Program
Initiating the DBAPLUS Program Interactively
Creating a DBAPLUS Job File from within the DBChange Program
Modifying the Job File
Running the DBAPLUS Program Independently
Using PARM Values
How DBAPLUS Restructures a Database
Possible Restructuring Problems
Restructuring the ORDERS Database
Ch 10. DBChange Plus Commands
DBChange Plus Command Formats
Summary of DBChange Plus Commands
ADD FIELD
ADD ITEM
ADD PASSWORD
ADD PATH
ADD SET
ADD SORT
BASE
CANCEL COMMANDS
CANCEL ERASE
CANCEL REPACK
CHANGE ATTRIBUTES
CHANGE BLOCKFACTOR
CHANGE BLOCKMAX
CHANGE CAPACITY
CHANGE DEVICECLASS
CHANGE ITEM
CHANGE ITEMSECURITY
CHANGE PASSWORD
CHANGE PRIMARYPATH
CHANGE SETSECURITY
CHECK BASE
CHECK PATH
CHECK SET
CONTROL
COPY
DELETE FIELD
DELETE ITEM
DELETE ITEMSECURITY
DELETE PASSWORD
DELETE PATH
DELETE SET
DELETE SETSECURITY
DELETE SORT
ERASE SET
EXIT
FIX BASE
FIX PATH
FIX SET
HELP
OUTPUT
PERFORM COMMANDS
PRINT SCHEMA
RECOVER ITEM
RECOVER SET
REDO
RENAME BASE
RENAME ITEM
RENAME SET
REORDER FIELD
REORDER ITEM
REORDER SET
REPACK SET
REVIEW BLOCKS
REVIEW FIELDS
REVIEW ITEMS
REVIEW PASSWORDS
REVIEW PATHS
REVIEW SETS
XEQ
Ap A. DBChange Plus Messages
DBChange Plus Messages (continued)
DBChange Plus Messages (continued)
DBChange Plus Messages (continued)
Ap B. ORDERS Schema
INDEX
Index