HP 3000 Manuals

CHANGE PRIMARYPATH [ DBChange Plus User's Guide ] MPE/iX 5.0 Documentation


DBChange Plus User's Guide

CHANGE PRIMARYPATH 

Changes the primary path of a detail data set.

Syntax 

     CHA[NGE] PRI[MARYPATH] DataSetName SearchItemName 

Parameters 

DataSetName         is the name of the detail data set whose primary path
                    is to be changed.

SearchItemName      is the name of the search item for the new primary
                    path.

Description 

Use this command to change the primary path of a detail data set.

Example 

     >change primarypath inventory stock# 

In this example, the primary path in the detail data set INVENTORY is
changed to the path defined by the STOCK# search item.

Before the change, the INVENTORY data set entry in the schema looks like
this:

     NAME:     INVENTORY   ,D(12,14/13,18);
     ENTRY:    STOCK#       (PRODUCT      ),   <---- to become primary path 
               ONHANDQTY                   ,
               SUPPLIER     (!SUP-MASTER  ),   <---- path to be changed 
               UNIT-COST                   ,
               LASTSHIPDATE ( DATE-MASTER ),
               BINNUM                      ;
     CAPACITY: 450(15);

After the change, the INVENTORY data set entry in the schema looks like
this:

     NAME:     INVENTORY   ,D(12,14/13,18);
     ENTRY:    STOCK#       (!PRODUCT     ),   <---- path now primary path 
               ONHANDQTY                   ,
               SUPPLIER     ( SUP-MASTER  ),   <---- path no longer primary 
               UNIT-COST                   ,
               LASTSHIPDATE ( DATE-MASTER ),
               BINNUM                      ;
     CAPACITY: 450(15);



MPE/iX 5.0 Documentation