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.
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
Kandy
_________________
Try and Try again…You will succeed atlast!!