Troubleshooting a Mobile Business Object Created Using SQL

Problem: SCHLOSS fails to parse isnull() with arguments and generates a syntax error.

Solution: Do not create a mobile business object using a select statement that includes the isnull() function, for example:
Select emp_id,isnull(termination_date,  '@OP["dd"="2008-12-31"]') from employee

The column information is not obtained in the Attributes and Columns mapping page.


Created September 17, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com