Error 1005030

"Query has an ambiguous table reference between prepare and open cursor (%2). %1"

Item Description

SQLCode

-1005030L

Constant

EMSG_INCONSISTENT_TABLES

SQLState

QTA30

ODBC 2 State

ERROR

ODBC 3 State

ERROR

Sybase Error Code

21145

Severity Code

14

Parameter 1

Location of the exception.

Parameter 2

table name

Probable cause

SA allows a base and temp table to both have the same table name. In some places, such as when a temp table is created in a stored procedure between the describe and open, IQ can find the base table in the describe and the temp table in the open, giving inconsistent results.


Created April 27, 2010. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com