These examples show the DDL that is generated when you
copy indexes between heterogeneous databases.
The generated DLL is shown on the Preview DDL page in the Paste
Database Objects wizard.
Table 1 shows examples of the DDL that is generated for copying
indexes from an Oracle Database 11g source database to a DB2® Version 9.7 for Linux, UNIX,
and Windows target database.
Table 1. Examples of copying indexes from Oracle Database 11g
to DB2 Version 9.7 for Linux, UNIX, and Windows databaseOracle Database 11g index definition |
Generated DDL for DB2 Version
9.7 for Linux, UNIX, and Windows database |
CREATE INDEX doc_idx1
ON document (doc_id);
|
CREATE INDEX DOC_IDX1
ON DOCUMENT (DOC_ID);
|
CREATE UNIQUE doc_uniq_idx1
ON document (created_date ASC);
|
CREATE UNIQUE INDEX DOC_UNIQ_IDX1
ON DOCUMENT (CREATED_DATE ASC);
|
CREATE INDEX doc_idx2
ON document(doc_id,language);
|
CREATE INDEX DOC_IDX2
ON DOCUMENT (DOC_ID, LANGUAGE);
|
CREATE INDEX doc_idx3
ON document
(doc_id ASC,
created_date ASC)
TABLESPACE index_tbsp;
|
CREATE INDEX DOC_IDX3
ON DOCUMENT
(DOC_ID ASC,
CREATED_DATE ASC)
IN INDEX_TBSP;
|
Table 2 shows examples of the DDL that is generated for copying
indexes from a DB2 Version 9.7
for Linux, UNIX, and Windows source
database to a DB2 Version 9.1
for z/OS® target database.
Table 2. Examples of copying indexes from a DB2 Version 9.7 for Linux, UNIX,
and Windows database to
a DB2 Version 9.1 for z/OS databaseDB2 Version
9.7 for Linux, UNIX, and Windows index
definition |
Generated DDL for DB2 Version
9.1 for z/OS database |
CREATE TABLE test19
(col1 CHAR(20),
col2 INTEGER
);
CREATE INDEX ix_test19
ON test19 (col1 ASC)
|
CREATE TABLE NEWTON.TEST19
(COL1 CHAR(20),
COL2 INTEGER
);
CREATE INDEX NEWTON.IX_TEST19
ON NEWTON.TEST19 (COL1 ASC);
|
CREATE TABLE test27
(col1 CHAR(20),
col2 VARCHAR(10),
col3 INTEGER,
col4 DECIMAL(10,9)
);
CREATE UNIQUE INDEX test_#_nww41
ON test27 (col1 ASC);
|
CREATE TABLE NEWTON.TEST27
(COL1 CHAR(20),
COL2 VARCHAR(10),
COL3 INTEGER,
COL4 DECIMAL(10 , 9)
)
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC;
CREATE UNIQUE INDEX NEWTON.TEST_#_NWW41
ON NEWTON.TEST27 (COL1 ASC);
|
Table 3 shows examples of the DDL that is generated for copying
indexes from a DB2 Version 9.1
for z/OS source database to
a DB2 Version 9.7 for Linux, UNIX, and Windows target
database.
Table 3. Examples of copying indexes from a DB2 Version 9.1 for z/OS database to a DB2 Version
9.7 for Linux, UNIX, and Windows databaseDB2 Version
9.1 for z/OS index definition |
Generated DDL for DB2 Version
9.7 for Linux, UNIX, and Windows database |
CREATE TABLE test19z
(col1 CHAR(20),
col2 INTEGER
);
CREATE INDEX ix_test19z
ON test19z (col1 ASC) ;
|
CREATE TABLE DB2ADMIN.TEST19Z
(COL1 CHAR(20) ,
COL2 INTEGER
) ;
CREATE INDEX DB2ADMIN.IX_TEST19Z
ON DB2ADMIN.TEST19Z (COL1 ASC);
|
CREATE TABLE test27z
(col1 CHAR(20),
col2 VARCHAR(10),
col3 INTEGER,
col4 DECIMAL(10,9)
);
CREATE UNIQUE INDEX test_#_nww41z
ON test27z (col1 ASC);
|
CREATE TABLE DB2ADMIN.TEST27Z
(COL1 CHAR(20) DEFAULT NULL,
COL2 VARCHAR(10) DEFAULT NULL,
COL3 INTEGER DEFAULT NULL,
COL4 DECIMAL(10 , 9) DEFAULT NULL
)
DATA CAPTURE NONE ;
CREATE UNIQUE INDEX DB2ADMIN.TEST_#_NWW41Z
ON DB2ADMIN.TEST27Z (COL1 ASC);
|