Hi John:

My app provides a report of entries in masters that are on a synonym chain.

It shows this:

 spdb
      Page      1 of     5

     Data Set                 Data Item           Message
                RelRec I-Rec
    Key Value

 SPUTIL-CI-AUTO   SPUTIL-COMMAND   ENTRY AT PRIMARY LOCATION         1      5
 KEY VALUE: APP

 SPUTIL-CI-AUTO   SPUTIL-COMMAND   SYNONYM ENTRY AT RECORD NO:   2      7
 KEY VALUE: TEXT

 SPUTIL-CI-AUTO   SPUTIL-COMMAND   ENTRY AT PRIMARY LOCATION         1      6
 KEY VALUE: DQ

 SPUTIL-CI-AUTO   SPUTIL-COMMAND   SYNONYM ENTRY AT RECORD NO:   2     10
 KEY VALUE: H



Works fine when the master key item is "X" "U" or "Z".

I am well aware of the nastiness of integer keys but I cannot exclude the
possiblity of this faux pas.

However, with integer keys, if the key value is between 1 and the capacity
then the key value will always hash to its primary location thus yielding no
synonyms.

I digress...

I am not excluding the possibility that any client site is not using these
types as key items, therefore my app is taking into consideration the existence
of integer keys on masters, either comp or packed.

As I said my app works just fine when all the master key items are of the "X"
"U" or "Z" flavor but the comp (J1, J2) and/or packed (P4, P8, P12, P16) are
difficult to extract when they are not the first item in the data set.

Brian.

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *