Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » Error Messages » SQL Anywhere error messages » SQL Anywhere error messages sorted by message text (D-K)

 

Derived table '%1' has no name for column %2

Error constant SQLE_NO_COLUMN_NAME
ODBC 2 State 37000
ODBC 3 State 42000
Parameter 1 Name of the derived table.
Parameter 2 Number of the column for which there is no name.
Severity 16
SQLCODE –163
SQLSTATE 52004
Sybase error code 209
Probable cause

The specified column of the derived table has no column name. Use a select list alias in the query specification or use a derived columns specifier.