Sybase Adaptive Server Anywhere - Page 828

Alphabetic list of error messages
810
Invalid expression in WHERE clause of Transact-SQL outer join
Item Value
SQLCODE -680
Constant SQLE_INVALID_TSQL_OJ_EXPRESSION
SQLSTATE 52W23
Sybase error code 301
ODBC 2 State 37000
ODBC 3 State 42000
An expression in the WHERE clause of a query which uses Transact-SQL
syntax contains a comparison of a column from the null-supplying table with
a subquery or an expression which references a column from another table.
Invalid expression near ’%1’
Item Value
SQLCODE -156
Constant SQLE_EXPRESSION_ERROR
SQLSTATE 42W08
Sybase error code 401
ODBC 2 State 37000
ODBC 3 State 42000
Parameter 1 The invalid expression.
You supplied an expression which the database server cannot understand.
For example, you may have tried to add two dates.
Probable cause
Probable cause