HP 3000 Manuals HP 3000 Manuals
Redefining the Primary Path in a Detail Data Set
To redefine the primary path in a detail data set containing two or more
paths, use the CHANGE PRIMARYPATH command. In this section, a new
primary path is redefined in the INVENTORY detail data set of the ORDERS
database. Before redefining a primary path, the REVIEW PATHS command
output looks like this:
DATA SET NO: 6 NAME: INVENTORY TYPE: D
SEARCH ITEM NAME MASTER SET NAME SORT ITEM NAME PRIMARY
================ ================ ================ =======
STOCK# PRODUCT
SUPPLIER SUP-MASTER LASTSHIPDATE Y <---- *
LASTSHIPDATE DATE-MASTER
>
*Supplier is currently the search item for the primary path.
In the example below, INVENTORY is the name of the detail data set
containing the primary path to be redefined. STOCK# is the search item
for the new primary path. Note that the search item must already be an
existing data item in the data set. The DBCPLUS program displays a
message confirming redefinition of the primary path.
>change primarypath inventory stock#
Redefinition of primary path accepted.
>
Refer to "CHANGE PRIMARYPATH" in chapter 10, "DBChange Plus Commands,"
for a detailed description of the command syntax and parameters.
If you want to verify that the primary path is changed, use the REVIEW
PATHS command. In the following example, you can see that the primary
path is changed to the path whose search item is STOCK#:
>review paths inventory
DATABASE NAME: ORDERS
REVIEW PATHS (FOR DETAIL DATA SET):
DATA SET NO: 6 NAME: INVENTORY TYPE: D
SEARCH ITEM NAME MASTER SET NAME SORT ITEM NAME PRIMARY
================ ================ ================ =======
STOCK# PRODUCT Y <---- *
SUPPLIER SUP-MASTER LASTSHIPDATE
LASTSHIPDATE DATE-MASTER
*STOCK# is now the search item for the primary path.
>