Toad World® Forums

Is it possible to pass automation variables between scripts in Toad Data Point?


#1

I am trying to create an automation script that will pick up all transactions that occured since the script was last run. I have created an automation variable and I can update the variable with the current date stamp information. However, I haven’t figured out how to save this information for use with the next run of the script to pick up transactions with a date stamp greater than the date stamp of my last run. Is it possible to pass automation variables between scripts? If so, would it be possible to get an example of passing an automation variable between automation scripts and using this variable as a bind variable in the query?

Thanks in advance for any assistance you can provide.


#2

I would do a select to file and export to a file with the current date. Then read this file into variable at beginning of automation script.

Oracle: select sysdate from dual.

You can connect to an Excel or Csv file and select from that file. Give it a try. If you need help let me know and I can put a sample together.