Alphabetic list of error messages
874
Subquery allowed only one select list item
Item Value
SQLCODE -151
Constant SQLE_SUBQUERY_SELECT_LIST
SQLSTATE 53023
Sybase error code 102
ODBC 2 State 37000
ODBC 3 State 42000
You entered a subquery which has more than one column in the select list.
Change the select list to have only one column.
Subquery cannot return more than one row
Item Value
SQLCODE -186
Constant SQLE_SUBQUERY_RESULT_NOT_UNIQUE
SQLSTATE 21W01
Sybase error code 512
ODBC 2 State 37000
ODBC 3 State 42000
You used a subquery that returns more than one row, in a context where only
a single row can be used. If the subquery is in the WHERE clause, you might
be able to use the IN keyword.
Probable cause
Probable cause
To Next Page
Loading...