Toad World® Forums

Automation Variable Substitution


#1

SELECT * INTO FOZIPCD_#wkendt# FROM FOZIPCD_temp

I am just beginning to work with the automation features of TOAD for DA and would like to know if the variable dereferencing feature #…# will work within a SQL / Query Builder Statement?

I am trying to get a table name in SQL Server named with a date suffix (wkendt=20101217) with the following statement:

Is this possible?

Thanks


#2

The dereferencing symbols #wkendt# are not used in a script. You would need to use the Find and Replace activity. In your script use some unique set of characters and then do a find and replace of those characters with the content of the variable.

IE: Select * INTO MYTABLE_&REPLACE& from table_temp

[cid:image001.png@01CBA057.5D2C3BD0]
image001.png