In the job creation XML, the staging_database, staging_database_for_table, and target_database tags are supported at the job level. When these values are specified, they are applied to all the table objects included in the job request. For non-table objects, if these values are supported, they need to be specified at the object level. These three tags are optional, and must be positioned after the <force_utility> tag.
<overwrite_existing_objects>true</overwrite_existing_objects> <force_utility>tptapi</force_utility> <staging_database><name>stagingDB</name></staging_database> <staging_database_for_table><name>stagingDBForTable</name></staging_database_for_table> <target_database><name>targetDB</name></target_database> ...