MAG KEY VALIDATE (2894)    REMOTE PROCEDURE (8994)

Name Value
NAME MAG KEY VALIDATE
TAG KVAL
ROUTINE MAGQBUT4
RETURN VALUE TYPE SINGLE VALUE
AVAILABILITY RESTRICTED
INACTIVE ACTIVE
DESCRIPTION
This is a an interface to the Database Server (DBS) utility:
Key Validator
 
The Key Validator extrinsic function verifies that new values contained 
in the FDA do not produce an invalid key. All keys in which any field in 
the FDA participates are checked. If the value for a field in a key being 
checked is not present in the FDA, the value used to verify the key is 
obtained from the previously filed data.
INPUT PARAMETER
  • FLAGS
    PARAMETER TYPE:   LITERAL
    MAXIMUM DATA LENGTH:   9
    REQUIRED:   NO
    SEQUENCE NUMBER:   1
    DESCRIPTION:   
    (Optional) Flags to control processing. The possible values are:
     
    Q  Quit when the first problem in the FDA is encountered.
    
  • FDA
    PARAMETER TYPE:   LIST
    MAXIMUM DATA LENGTH:   99
    REQUIRED:   YES
    SEQUENCE NUMBER:   2
    DESCRIPTION:   
    The root of the FDA that contains the data to be checked. The array can 
    be a local or global one. See the Database Server Introduction for 
    details of the structure of the FDA.
    The value of fields in the FDA must be the internal value. Do not pass 
    external (e.g., unresolved pointer values, non-FileMan dates) in the FDA.
    No action is taken on fields in the referenced FDA if those fields do not 
    participate in a Key defined in the KEY file.
    
RETURN PARAMETER DESCRIPTION
This Boolean function returns a 1 if key integrity is not violated by any 
value in the FDA and a -1 followed by a carat delimiter and an error 
message describing the nature of an invalid key that  was produced by any
of the values. 
 
740 A duplicate key is produced by a field's new value.
742 A value for a field in a key is being deleted.
744 Not all fields in a key have a value.