Toad World® Forums

Using parameters with the Data Copy Utility command line call

Toad for Oracle V9.5

I’m trying to automate a Copy Data script using Data Copy Utility from the cmd line. I generated the script and created a Perl script to call it. I want to pass in a parameter though to dynamically change the WHERE clause in the Table Listings section. In the example below I would like to change ‘01-JAN-2014’ to ‘&1’ and have this parameter passed into the script from my Perl script.

#Table listings…

TABLE=MySchema.MyTable

WHERECLAUSE[MySchema.MyTable]=WHERE end_date = ‘01-JAN-2014’{NL}

Is there a way to change this to the following?

WHERECLAUSE[MySchema.MyTable]=WHERE end_date = ‘&1’{NL}

No, it doesn’t handle parameters like that, sorry.

From: jcone [mailto:bounce-jcone@toadworld.com]

Sent: Tuesday, September 03, 2013 12:40 PM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Using parameters with the Data Copy Utility command line call

Using parameters with the Data Copy Utility command line call

Thread created by jcone

Toad for Oracle V9.5

I’m trying to automate a Copy Data script using Data Copy Utility from the cmd line. I generated the script and created a Perl script to call it. I want to pass in a parameter though to dynamically
change the WHERE clause in the Table Listings section. In the example below I would like to change ‘01-JAN-2014’ to ‘&1’ and have this parameter passed into the script from my Perl script.

#Table listings…

TABLE=MySchema.MyTable

WHERECLAUSE[MySchema.MyTable]=WHERE end_date = ‘01-JAN-2014’{NL}

Is there a way to change this to the following?

WHERECLAUSE[MySchema.MyTable]=WHERE end_date = ‘&1’{NL}

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.