The generated DDL is shown on the Preview DDL page in the Paste Database Objects wizard.
Table 1 shows an example of the DDL that is generated for copying a sequence from an Oracle Database 11g source database to a DB2® Version 9.7 for Linux, UNIX, and Windows target database.
Oracle Database 11g sequence definition | Generated DDL for DB2 Version 9.7 database |
---|---|
CREATE SEQUENCE customer_number START WITH 10000 INCREMENT BY 10 NOCYCLE; |
CREATE SEQUENCE CUSTOMER_NUMBER START WITH 10000 INCREMENT BY 10 NOCYCLE; |
Table 2 shows an example of the DDL that is generated for copying a sequence from a DB2 Version 9.7 for Linux, UNIX, and Windows source database to an Oracle Database 11g target database.
DB2 Version 9.7 database sequence definition | Generated DDL for Oracle Database 11g |
---|---|
CREATE SEQUENCE customer_number START WITH 10000 INCREMENT BY 10 NOCYCLE; |
CREATE SEQUENCE CUSTOMER_NUMBER START WITH 10000 INCREMENT BY 10 NOCYCLE; |