Hi All,
Is there a way to influence the Data Movement Tool to use UR when extracting the data from the source database?
Thanks,
Scott
Topic
-
Re: Data Movement Tool using UR?
2013-03-28T22:11:18ZThis is the accepted answer. This is the accepted answer.
Depending upon source database SQL syntax for UR, you could modify the SQL statement in the <dbname>.tables file.
e.g.
"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.