Creating Alias for Sequence object using RC/Migrator

Products

• RC/Migrator for DB2 for z/OS

Issue/Introduction

RC/Migrator for Db2 for z/OS (RCM) is not handling a CREATE ALIAS x FOR SEQUENCE Y.Z.

Resolution

An AUTOMAP compare is being used to compare some input DDL containing a create of an alias on a sequence object:

CREATE ALIAS authid.alias_id FOR SEQUENCE
    authid1.sequence_id;

The result is invalid DDL: CREATE  ALIAS authid.alias_id FOR "SEQUENCE"."." ;

 RMA254E SYNTAX ERRORS WERE FOUND. PLEASE CHECK OUTPUT DDL FILE FOR   MORE INFORMATION ON THE ERRORS.                               
   DDL00408: ALIAS cannot be created because OBJECT                  
             SEQUENCE.. does not exist.    

Currently the Alias for Sequence object is not supported by RC/Migrator. 

Currently in RC/Migrator an ALIAS can only be created for TABLES and VIEWS. See Alias Create Option

"The Create Alias option enables creation of an alternative name for an existing table or view. "

Additional Information

Aliases