gtpo1m1tOperations

ZBROW KEYPATH-Add, Display, or Remove a Key Path

Use this command to add, display, or remove an alternate key path that has been defined for a collection.

Requirements and Restrictions

Format




ADD
creates a key path on the key path field that is specified by the displacement and length values for the specified collection.

colname
is the 1- to 32-character alphanumeric name of the target collection.

keypathname
is the 1- to 16-character alphanumeric name of the key path that will be added, displayed, or removed.

displacement
specifies the 0-based hexadecimal displacement to the key path field in the data element.

length
specifies the hexadecimal length of the key path field.

DISPlay
displays information about the defined key paths for the specified collection.

ALL
displays all the defined key paths for the specified collection.

REMove
removes the specified key path for the collection.

Additional Information

Examples

In the following examples, the ZBROW QUALIFY command with the SET parameter specified was issued to set the data store qualification to FAP.BSS before the examples were created.

A key path is added to the DICT1 key sorted set collection in the following example. The key path will be built using the values in the field starting at displacement 1 for a length of 8 characters for every data element in the collection.

+--------------------------------------------------------------------------------+
|User:      ZBROW KEYPATH ADD DICT1 INDEX1 1 8                                   |
|                                                                                |
|System:    BROW0602I 12.38.16 BROWSER QUALIFIED FOR DSNAME FAP.BSS              |
|           BROW0901I 12.38.17 KEYPATH SUCCESSFULLY ADDED                        |
|           BROW0910I 12.38.17 KEYPATH REQUEST COMPLETED                         |
+--------------------------------------------------------------------------------+

All the alternate key paths defined for the DICT1 key sorted set collection are displayed in the following example. The following fields are displayed:

 KEYPATH NAME 
is the name of the key path.

 DISPLACEMENT 
is the 0-based hexadecimal displacement of the key path field.

 LENGTH 
is the hexadecimal length of the key path field.

 COUNT 
is the decimal number of data elements accessible by using this key path.

status
specifies whether or not the build is completed successfully for this key path.
+--------------------------------------------------------------------------------+
|User:      ZBROW KEYPATH DISP DICT1 ALL                                         |
|                                                                                |
|System:    BROW0602I 12.46.09 BROWSER QUALIFIED FOR DSNAME FAP.BSS              |
|           BROW0903I 12.46.09 KEYPATH INFORMATION DISPLAY                       |
|           KEYPATH NAME KEYPATH1          ID   1                                |
|           DISPLACEMENT 0001  LENGTH    8  COUNT         0                      |
|           BUILD COMPLETE                                                       |
|           KEYPATH NAME KEYPATH2          ID   2                                |
|           DISPLACEMENT 0020  LENGTH   50  COUNT         0                      |
|           BUILD COMPLETE                                                       |
|           END OF DISPLAY                                                       |
|           BROW0910I 12.46.09 KEYPATH REQUEST COMPLETED                         |
+--------------------------------------------------------------------------------+

The INDEX1 key path is removed from the DICT1 key sorted set collection in the following example.

+--------------------------------------------------------------------------------+
|User:     ZBROW KEYPATH REMOVE DICT1 INDEX1                                     |
|                                                                                |
|System:   BROW0602I 12.39.25 BROWSER QUALIFIED FOR DSNAME FAP.BSS               |
|          BROW0902I 12.39.26 KEYPATH SUCCESSFULLY REMOVED                       |
|          BROW0910I 12.39.26 KEYPATH REQUEST COMPLETED                          |
+--------------------------------------------------------------------------------+

Related Information