You can add or change a qualifier in the generated DDL only by modifying the SQL script in the SQL and XQuery editor.
CCSID is set to UNICODE in the generated DDL only when the copied table contains a column of type GRAPHIC or VARGRAPHIC.
To extract the consistent data from a parent-child relationship table with a limited number of rows, specify query filters on the Data Movement page of the Paste Database Objects wizard.
Copy the cust_customer table (parent table) and the cust_crdt_card table (child table) in the GOSALES demo database.
Table 1 shows the information to specify in the Filter and Row Limit columns of the grid on the Data Movement page of the wizard.
Table | Filter | Row Limit |
---|---|---|
cust_customer | ORDER BY cust_code | 1000 |
cust_crdt_card | WHERE cust_code in ( SELECT cust_code FROM gosalesct.cust_customer ORDER BY cust_code FETCH FIRST 1000 ROWS ONLY) |
Oracle data type | Results |
---|---|
BFILE | Column is mapped to DB2 BLOB data type; data is not copied. |
INTERVAL YEAR TO MONTH | Mapped to DB2 CHAR data type. |
INTERVAL DAY TO SECOND | Mapped to DB2 CHAR data type. |
NUMBER( p,-s ) | Mapped to DB2 NUMBER( p,0 ) data type. |
NUMBER( p,s ) where s > p | Column is not created; data is not copied. |
TIMESTAMP WITH LOCAL TIME ZONE | Column is not created; data is not copied. |
TIMESTAMP WITH TIME ZONE | Column is not created; data is not copied. |
XMLTYPE | Column is mapped to DB2 XML data type; data is not copied |