DSNH104I E csectname LINE nnnn COL cc ILLEGAL SYMBOL "token". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: token-list

Explanation

A syntax error was detected where the symbol "token" occurs in the SQL statement. The list of symbols that might be legal shows some alternate symbols that could possibly be correct at that point, if the preceding part of the statement is entirely correct.

However, the preceding part of the statement might be incorrect. For example, if an important keyword is omitted, Db2 detects the error later, and not always immediately after the point where the keyword should appear. The list of alternate symbols are only suggestions.

System action

If the containing SQL statement is a declaration, it is discarded. If the containing SQL statement is executable, it is replaced by host language statements that will, if executed, set an error code in the SQLCA.

User response

Correct the statement and precompile the program again.

Severity

8 (error)