DSNH051I E csectname LINE nnnn COL cc sqltype name PREVIOUSLY DECLARED OR REFERENCED

Explanation

The variable sqltype is TABLE, CURSOR, or STATEMENT. The identifier name was already defined with the given sqltype. The definition might have occurred implicitly. For example, name might have been found in the FROM clause of a SELECT, causing it to be defined as a table.

System action

The name is installed in the symbol table as a duplicate.

User response

Remove duplicate definitions, or correct the references. Avoid implicit definitions by inserting (or including) table declarations before they are referenced. Check the number of passes used. Use the cross-reference and source listings to help resolve this type of error.

Severity

8 (error)