Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Issue when opening TDP v3.2 automation script in v4.2.1
설명
Issue when opening and running Toad Data Point v3.2 automation scripts in v4.2.1 that contain "If Condition" actions:
"Activity 'Execute_File_script' validation failed: Toad has detected some symbols within the SQL indicating you might be using bind variables. Please define the following variable(s):
DATE_VARIABLE"
Example of script:
원인
This issue is caused by some variables and "If conditions" not being handled the same way between Toad Data Point v4.2.1 and v3.2
해결 방안
SOLUTION
For the provided example, the solution is to split the activities into two groups as per below.