SQL/MX 2.x Installation and Management Guide (H06.10+, J06.03+)

Planning Database Security and Recovery
HP NonStop SQL/MX Installation and Management Guide—544536-007
5-39
Fixup of Tables with Referential Integrity Constraints
<cat_name>.DEFINITION_SCHEMA_VERSION_1200.OBJECTS O,
<cat_name>.DEFINITION_SCHEMA_VERSION_1200.OBJECTS O1,
<cat_name>.DEFINITION_SCHEMA_VERSION_1200.TBL_CONSTRAINTS T,
<cat_name>.DEFINITION_SCHEMA_VERSION_1200.REF_CONSTRAINTS R
WHERE
CA.CAT_UID = S.CAT_UID AND
CA.CAT_NAME='<cat_name>' AND
S.SCHEMA_UID=O.SCHEMA_UID AND
O.OBJECT_UID=T.CONSTRAINT_UID AND
O.OBJECT_SECURITY_CLASS='UT' AND
O.OBJECT_NAME_SPACE='CN' AND
O1.SCHEMA_UID=S.SCHEMA_UID AND
O1.OBJECT_UID=T.TABLE_UID AND
O1.OBJECT_SECURITY_CLASS='UT' AND
O1.OBJECT_TYPE='BT' AND
T.CONSTRAINT_UID = R.CONSTRAINT_UID AND
( R.UPDATE_RULE <> 'NA' OR
R.DELETE_RULE <> 'NA') AND
( R.UPDATE_RULE <> 'RE' OR
R.DELETE_RULE <> 'RE ')
;
where,
<cat_name> is the name of the user catalog.
<node_name> is the name of the node.