Database Management
Reference Manual
Cleanup and the CLEANUp Command
Cleanup and the CLEANUp Command
The command CLEANUp cleans up unwanted references in the database. It is possible to remove null references and unresolved/invalid references.
The logical attributes NULLREf, INVREF and UNRESOlved is used to sort out whether a reference attribute points to something valid or not. The syntax is the same for all three:
Q NULLRE (ATTNAME
att
)
Answers the question is the attribute att null (=0/0)?
Q UNRESO (ATTNAME
att
)
Is the attribute att pointing to an element whose existence we cannot find and verify? It could be that the database is missing or that the reference is truly invalid.
Q INVREF (ATTNAME
att
)
Is the attribute pointing to an element that is non-existent? This differs from unresolved in that the database that should accommodate the missing element is present in the active mdb.
The Cleanup command, syntax:
CLEANU/P NULL/REF | INVALID | UNRES/OLVED
attribute
[ON noun] [FOR ele] [SETNULL | DELETE]
Examples:
CLEANU NULL STLREF ON EQUI DELETE
Deletes all EQUI with STLREF equal null (=0/0)
CLEANU UNRES CATREF FOR /PIPES SETNULL
Sets all unresolved CATREF in the /PIPES hierarchy to null (=0/0)
CLEANU INVALID CATREF
Sets all unresolved CATREF in the hierarchy under CE to null
1974 to current year.
AVEVA Solutions Limited and its subsidiaries. All rights reserved.
