Preparing and Executing the Program › Creating the Access Module › Altering an Access Module

Altering an Access Module

What You Can Change

With an ALTER ACCESS MODULE statement, you can change any specification that you made on the CREATE ACCESS MODULE statement. You can add, drop, or replace RCMs.

Note: For more information about altering an access module, see the ALTER ACCESS MODULE statement in the CA IDMS SQL Reference Guide.

Changing Schema-name Mapping

To change the schema-name mapping for the access module, you must reprocess all RCMs by specifying the REPLACE ALL parameter, as in this example:

EXEC SQL
  ALTER ACCESS MODULE EMPINFO1
     REPLACE ALL
       MAP EMP_SCH TO EMP_PRODSCH,
       MAP NULL TO EMP_PRODSCH
END-EXEC.