CSE Installation and Configuration › Start the Clients and Communicate with a CSE › Administrative Tasks › Setting Strict or Relaxed Migration Rules (Optional)

Setting Strict or Relaxed Migration Rules (Optional)

To set the CSE for strict migration rules using your SQL command interpreter, such as SQLPlus for Oracle, connect to the Encyclopedia Database and enter the following commands:

UPDATE SASC SET AT_AGG_ACT = 'R' WHERE AT_FROM_OBJ_CODE = 257 AND
AT_ASSOC_CODE IN (631, 632) AND AT_RELEASE = 'schema-level';
UPDATE SASC SET AT_AGG_ACT = 'X' WHERE AT_FROM_OBJ_CODE = 167
AT_ASSOC_CODE = 562 AND AT_RELEASE = 'schema-level';
UPDATE SASC SET AT_AGG_ACT = 'C' WHERE AT_FROM_OBJ_CODE = 167 AND
AT_ASSOC_CODE = 563 AND AT_RELEASE = 'schema-level';
COMMIT

schema-level

Specifies the current schema level.

Note: For the schema designation for Current Schema, see the Release Notes.

To set the CSE for relaxed migration rules using your SQL command interpreter, such as SQLPlus for Oracle, connect to the Encyclopedia Database and enter the following commands:

UPDATE SASC SET AT_AGG_ACT = 'X' WHERE AT_FROM_OBJ_CODE = 257 AND
AT_ASSOC_CODE IN (631, 632) AND AT_RELEASE = 'schema-level';
UPDATE SASC SET AT_AGG_ACT = 'X' WHERE AT_FROM_OBJ_CODE = 167 AND
AT_ASSOC_CODE IN (562, 563) AND AT_RELEASE = 'schema-level';
COMMIT;

In a multi-encyclopedia environment, to implement relaxed migration rules for Encyclopedias with different schema levels, define this set of commands for each different schema level.