Issue in loading "?" as first character in the field.

Database

Issue in loading "?" as first character in the field.

Hi,

I am facing issue in loading question mark(?) as first character after space for a field in the table.

For example

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!

1 REPLY
N/A

Re: Issue in loading "?" as first character in the field.

I assume you run it in SQL Assistant?

Go to Tools- Options - Query and uncheck Allow use of Named Parameters in queries


Dieter