HP 3000 Manuals HP 3000 Manuals
Summary of Commands to Change Data Sets DBChange Plus has several commands for changing data sets in the database. Some deal with several types of data set changes, while others are specific to data set security or paths. For example, the ADD SET command deals with the data set name, its type, the order it appears in the data set list, the key and search items, and so on; while the ADD PATH command deals only with adding a path to a detail data set. This chapter covers only those commands that deal with several types of changes to a data set. For information about paths and sort items, refer to chapter 6, "Changing Paths in a Detail Data Set." For information about changing data set security, refer to chapter 7, "Changing Database Security." Note that some data item commands can affect fields in a data set, for instance, DELETE ITEM and RECOVER ITEM. These commands are discussed in chapter 4, "Changing Data Items," and chapter 10, "DBChange Plus Commands." Table 5-1 alphabetically lists the commands that change data sets and summarizes their functions.
NOTE * Before invoking any of the following commands, you must log on to the system as the database creator, run the DBCPLUS program, and specify the database that you want to restructure. Refer to chapter 1, "Introduction to DBChange Plus." * The DBChange commands are not actually applied until the DBAPLUS program is used. Refer to chapter 9, "Applying Changes to the Database Structure."
Table 5-1. Summary of Commands to Change Data Sets ---------------------------------------------------------------------------------------------- | | | | | Command | Keyword | Description | | | | | ---------------------------------------------------------------------------------------------- | | | | | ADD | FIELD | Adds a field (data item) to a manual master or | | | | detail data set. | | | | | | | PATH | Adds a path from a detail data set to a master data | | | | set (path command only). | | | | | | | SET | Adds a new master or detail set to the database. | | | | | | | SORT | Adds a new sort item for a search item. If a sort | | | | item already exists in the data set, the ADD SORT | | | | command replaces the existing sort item. | | | | | ---------------------------------------------------------------------------------------------- | | | | | CHANGE | BLOCKFACTOR | Changes the blocking factor of a data set. | | | | | | | BLOCKMAX | Changes the maximum physical block length of one or | | | | more data sets. | | | | | | | CAPACITY | Changes the capacity of a data set. | | | | | | | DEVICECLASS | Changes the device (disk) on which a data set | | | | resides. | | | | | | | PRIMARYPATH | Changes the primary path for a detail data set that | | | | has at least two paths (path command only). | | | | | | | SETSECURITY | Changes user class access to a data set (security | | | | command only). | | | | | ---------------------------------------------------------------------------------------------- | | | | | DELETE | FIELD | Deletes a field from a manual master or detail data | | | | set. | | | | | | | PATH | Deletes the path from a detail data set to a master | | | | data set (path command only). | | | | | | | SET | Deletes a master or detail data set and its | | | | associated paths from the database. | | | | | | | SETSECURITY | Deletes all security specifications from a master | | | | or detail data set (security command only). | | | | | | | SORT | Deletes a sort item from a search item in a detail | | | | data set. | | | | | ---------------------------------------------------------------------------------------------- | | | | | RECOVER | SET | Cancels a data set deletion. | | | | | ---------------------------------------------------------------------------------------------- | | | | | RENAME | SET | Renames a data set. | | | | | ---------------------------------------------------------------------------------------------- | | | | | REORDER | FIELD | Reorders the field sequence in a manual master or | | | | detail data set. | | | | | | | SET | Reorders the data set sequence in the schema data | | | | set list. | | | | | ----------------------------------------------------------------------------------------------