A query of an incorrect statement does not fail with an error and may have returned an incorrect result set.
For example, Even if you have specified the same correlation name in the same FROM clause, a query does not fail with an error,
Sample error message
Could not execute statement.
More than one table is identified as 'table2'
SQLCODE=-139, ODBC 3 State="42000"
And, this behavior also occurs on SAP SQL Anywhere.
- SAP IQ 16.0
- SAP IQ 15.x
- SAP SQL Anywhere 16.0
- SAP SQL Anywhere 12.0
- SAP SQL Anywhere 11.0
KBA , BC-SYB-IQ , Sybase IQ , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.