In this post, you’ll learn about the error message -104 illegal symbol token valid symbols are token-list in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-104 illegal symbol token valid symbols are token-list
Reason for the Error
A syntax error in the SQL statement was detected at ‘token’. A partial list of valid tokens, ‘token-list’, is provided.� This list assumes that the statement is correct up to that point, and only as many tokens are listed as will fit.
Solution
Examine the statement in the area of the specified token.If you are executing the SQL statement dynamically under TSO, be sure that if the data set containing the DSNHDECP load module has not been included in your LINKLSTxx, it has been included in STEPLIB statements in:1.� The DB2 start-up procedure 2.� The TSO logon procedure or batch job JCL.
