I have some sql scripts that use variables to update tables in my database. I currently run them as execute to file activities within an automation script. While testing TDP 3.5, I attempted to simply drop these scripts in an import activity using the same variables - #variable#.
However, when I attempt to click next on the Enter Query screen, I get an error:
It seems like the wizard is trying to pass the tdp variable to the AS400 instead of translating the variable into the actual value and then passing it to the database. I am using one of the new IBM DB2 iseries connections to run the script. Maybe this feature is not available for iseries? If anyone has any insights I would appreciate it.