Is there a way to influence the Data Movement Tool to use UR when extracting the data from the source database?
This topic has been locked.
1 reply Latest Post - 2013-03-28T22:11:18Z by SystemAdmin
Pinned topic Data Movement Tool using UR?
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-03-28T22:11:18Z at 2013-03-28T22:11:18Z by SystemAdmin
SystemAdmin 110000D4XK708 PostsACCEPTED ANSWER
Re: Data Movement Tool using UR?2013-03-28T22:11:18Z in response to SystemAdminDepending upon source database SQL syntax for UR, you could modify the SQL statement in the <dbname>.tables file.
"SCHEMA"."TABLE":SELECT * FROM "SCHEMA"."TABLE" can be changed to
"SCHEMA"."TABLE":SELECT * FROM "SCHEMA"."TABLE" WITH UR --> If this is DB2.
If you change this file, use command line to run the tool otherwise GUI may again rewrite the SQL.
Use GUI to generate the scripts and then leave it.
Go to output dir, change file and then run unload command manually.