Topic
1 reply Latest Post - ‏2013-03-28T22:11:18Z by SystemAdmin
SystemAdmin
SystemAdmin
708 Posts
ACCEPTED ANSWER

Pinned topic Data Movement Tool using UR?

‏2013-03-28T20:44:43Z |
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
Updated on 2013-03-28T22:11:18Z at 2013-03-28T22:11:18Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    708 Posts
    ACCEPTED ANSWER

    Re: Data Movement Tool using UR?

    ‏2013-03-28T22:11:18Z  in response to SystemAdmin
    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.