logo  
Google
 

DB2 SQL-Error: -120

SQLState: 42805

Short Description: C AN INTEGER IN THE ORDER BY CLAUSE DOES NOT IDENTIFY A COLUMN OF THE RESULT

The ORDER BY clause in the statement contains a column number that is either less than one, or greater than the number of columns of the result table (the number of items in the SELECT clause). System action: The statement cannot be executed. Programmer response: Correct the syntax of the ORDER BY clause such that each column identifier properly denotes a column of the result table.

 <-  BACK TO INDEX