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.

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