DSXchange

Hi,

I am using DS 8.5 and when I give any user-defined SQL statement in the ODBC statge in "SQL Select Statement" it displays a warning like Invalid Property Value Expecting :Other input

Even though it is during user defined query is mentioned the job runs fine without issues.

Just curious to know if anything sepcific needs to be done to get rid of this.

Appericiate your help, Thanks.

Is there a way by which the mentioned issue be addressed.

Thanks for your time.

So this happens with any user-defined SQL? Can you give us an example of one that generates this warning?

It is because of having some functions in the your SQL. Do you have a cast or something like that? If you remove them, then you will not see this alert message. Of course the job runs fine