Expecting :other input

xch2005 · Post by **xch2005** » Wed Mar 28, 2012 3:46 pm

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.

xch2005 · Post by **xch2005** » Tue Apr 17, 2012 2:40 pm

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

Thanks for your time.

chulett · Post by **chulett** » Tue Apr 17, 2012 4:50 pm

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

kandyshandy · Post by **kandyshandy** » Tue Apr 17, 2012 9:33 pm

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