Sybase Adaptive Server Anywhere - Page 773

CHAPTER 10 Database Error Messages
755
Column %1 in foreign key has a different definition than primary
key
Item Value
SQLCODE -113
Constant SQLE_INVALID_FOREIGN_KEY_DEF
SQLSTATE 53030
Sybase error code 1721
ODBC 2 State 42000
ODBC 3 State 42000
Parameter 1 Name of the problem column.
The data type of the column in the foreign key is not the same as the data
type of the column in the primary key. Change the definition of one of the
columns using ALTER TABLE.
Column ’%1’ found in more than one table -- need a correlation
name
Item Value
SQLCODE -144
Constant SQLE_COLUMN_AMBIGUOUS
SQLSTATE 52002
Sybase error code 209
ODBC 2 State 37000
ODBC 3 State 42000
Parameter 1 Name of the ambiguous column.
You have not put a correlation name on a column that is found in more than
one of the tables referenced in a query. You need to add a correlation name
to the reference.
Probable cause
Probable cause