Hello,
I created a MySQL query/TDR job embedded in a TAS using a MySQL db. Typically I would use parameter “=:#variable#”, but MySQL won’t allow this type of parameter. I tried using MySQL parameter “=@#variable#” but doesn’t identify as a parameter and no records are returned. I tried running the TDR job directly and doesn’t prompt a parameter value.
TAS:
Variable value: #Loop_data_1_SQL.communication_contact#
Variable name: communication_contact
TDR:
Query snipit: apd.COMMUNICATION_CONTACT =@#Loop_data_1_SQL.communication_contact#
Toad Data Point 3.4 and 4.0 - no luck in either version.
Thanks