The generated DDL is shown on the Preview DDL page in the Paste Database Objects wizard. In addition to the table definition, the generated DDL can contain SQL statements and SQL clauses for options that you select in the wizard.
Table 1 shows an example of the DDL that is generated for copying a table from an Oracle Database 11g source database to a DB2® Version 9.7 for Linux, UNIX, and Windows target database.
Oracle Database 11g table definition | Generated DDL for DB2 Version 9.7 for Linux, UNIX, and Windows database |
---|---|
|
|
Table 2 shows an example of the DDL that is generated for copying a table from a DB2 Version 9.7 for Linux, UNIX, and Windows source database to an Oracle Database 11g target database.
DB2 Version 9.7 for Linux, UNIX, and Windows database table definition | Generated DDL for Oracle Database 11g |
---|---|
|
|
Table 3 shows examples of the DDL that is generated for copying a table from a DB2 Version 9.7 for Linux, UNIX, and Windows source database to a DB2 Version 9.1 for z/OS® target database.
DB2 Version 9.7 for Linux, UNIX, and Windows database table definition | Generated DDL for DB2 Version 9.1 for z/OS |
---|---|
|
|
|
|
Table 4 shows examples of the DDL that is generated for copying a table from a DB2 Version 9.1 for z/OS source database to a DB2 Version 9.7 for Linux, UNIX, and Windows target database.
DB2 Version 9.1 for z/OS database table definition | Generated DDL for DB2 Version 9.7 for Linux, UNIX, and Windows |
---|---|
|
|
|
|