-783   SELECT LIST FOR CURSOR cursor-name IN FOR STATEMENT IS NOT VALID. COLUMN column-name IS NOT UNIQUE

Explanation

The SELECT list in the FOR statement must contain unique column names. The SELECT list specified either contains duplicate column names or unnamed expressions.
  • If two column names are the same, the column name is column-name.
  • If the problem is the result of unnamed expressions then *N is returned for column-name.

System action

The statement cannot be processed.

Programmer response

Specify unique column names in the SELECT list specified in the FOR statement.

SQLSTATE

42738