Administrator Command Reference Manual
Command Details : Detailed Descriptions of Commands : EXTERNAL (Data Integrity Checking)
EXTERNAL (Data Integrity Checking)
Function:
Checks that all external references point to DBs of appropriate types.
Description:
The elements in some types of DB have reference or reference array attributes which can point to elements in other DBs. If you use the EXTERNAL command, DICE will check that all external references point to DBs of appropriate types. For example, a reference attribute in a MODEL DB which points to a Draft (PADD) DB must be illegal, but a reference attribute pointing to a Catalogue DB will be accepted.
This command cannot be used in stand-alone mode because only one DB file can be accessed at a time.
EXTERNAL NOCHECK is the default. In this mode DICE does not cross-check any references to other DBs. This setting is used by standalone DICE (and REMOTE CHECK).
If EXTERNAL CHECK is specified, the following tests are applied to each external DB to which reference is made:
•
Does the referenced DB exist?
•
Is the referenced DB of a valid type?
•
Is the position pointed to within the limits of the referenced DB? Note that in the case of a DB which has copies, DICE only checks that the position pointed to is within the limits of the largest copy.
A non-fatal error message is produced for each invalid external reference found.
The EXTERNAL REJECT option should normally be chosen only when you are certain that the DB which is being checked should not contain any external references. If this setting is used, any external reference found in the DB will be reported as a fatal error and further checking will be abandoned.
If the DICE option CHECK FILES is used, no external reference checking can be done for that file and EXTERNAL NOCHECK will be assumed.
Examples:
EXTERNAL CHECK
EXTERNAL NOCHECK
EXTERNAL REJECT
An example of the output when EXTERNAL CHECK is specified:
External databases referenced
_____________________________
 
     Number   Name             No of references
     ______   ____             ________________
 
         8     GLB/DESI               41
        31     TECHP/TPDESI            4 
Command Syntax:
>--- EXTernal ---+--- NOCHeck* ---.
                 |                |
                 |--- CHECK ------+-- PREFERENCE
                 |                |
                 ‘--- REject -----+--->
The default is NOCHECK.
1974 to current year. AVEVA Solutions Limited and its subsidiaries. All rights reserved.
AVEVA Logo