Unfortunately, I cannot send print screens of the test I created, but here’s what I did in my test…
Create a Variable action
Added a Create File action that contained the select stmt and the variable. This will write the query (and the contents of your variable) to a file.
(Eg. In the Contents section: SELECT * FROM MYTABLE WHERE NAME = %MYVAR%)
- Added a Execute Script action that runs this file.
You could also put the main select statement in a variable as well, and then the Create File content would just have both variables back to back (%QUERY%%MYVAR%).
From: WetSprocket [mailto:bounce-WetSprocket@toadworld.com]
Sent: Tuesday, February 11, 2014 10:47 AM
Subject: RE: [Toad for Oracle - Discussion Forum] Automation Designer variables for data export
RE: Automation Designer variables for data export
Reply by WetSprocket
I have created a test app in Automation Designer that creates a variable, tests the variable (which it passes) and displays the variable in a message. Now I want to export the results of a
query (e.g., SELECT * FROM MYTABLE WHERE NAME = %MYVAR%), but I can’t get it to recognize the variable. I don’t know if it is a matter of syntax or if this functionality is not available in T4O.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
this post as spam/abuse.