Check the obvious first: 1. Make sure you are not running in ANSI mode. (Select * From DBC.Sessioninfo Where Username = User - The TransactionMode should be set to 'T') 2. If you are running in Bteq, make sure there is no "Begin Transaction" before the Replace strings. 3. If you are running in SQL Assistant, make sure you use the Execute, not the Execute Parallel (the single pair of feet, not the army squad!)
After this, check your SQL assistant and Teradata levels. I had a similar problem on V2R6, but I dont get it on Teradata 12/ SQL Assistant 12.
If all else fails, wrap a BT/ ET around each Replace Macro!