You can copy partial data from one or more Partitioned Primary Index (PPI) table when you copy an entire database using ARC.
If you specify a table that does not exist on the target, the table is created and partial data copied to the table.
An error results if you try to copy partial data from a non-PPI table when copying the entire database.
When copying an entire database, if a table specified as "included" is not being renamed, relocated, or partially copied, the specified table element is ignored.
- Open the parameters.xml file that has the job definition information for the job.
- Under the database name, add the selection="included" attribute to the table element.
- Add the <name> element and specify the table name.
- Add a <sql_where_clause> element and specify the WHERE restriction.
- Add a <key_columns> element and specify the column of the partial data.
In the following example, partial data from the orderdate column of the DBName.PPIOrders table is copied to the target DBName.PPIOrders table.
<database selection= "included"> <name>DBName</name> <table selection="included"> <name>PPIOrders</name> <sql_where_clause> <![CDATA[WHERE orderdate IN (select orderdate from "DBName"."PPIOrders")]]> </sql_where_clause> <key_columns> <key_column>orderdate</key_column> <key_column>orderkey</key_column> </key_columns> </table> </database>