I am facing issue in loading question mark(?) as first character after space for a field in the table.
INSERT INTO TEST SET NAME = " ?A BCD" ;
I ran the above query. The teradata considering it as parameter variable and asking for value, after encountering the question mark(?) when we cancel it the correct value is loaded into the field, but the requirement is to load it exactly what we receiving from the source.
Please provide your valuable inputs to solve this issue.
Thanks in advance!
I assume you run it in SQL Assistant?
Go to Tools- Options - Query and uncheck Allow use of Named Parameters in queries