In this post, you’ll learn about the error message -199 illegal use of keyword keyword.� token token-list was expected in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-199 illegal use of keyword keyword.� token token-list was expected
Reason for the Error
A syntax error was detected in the statement at the point where the keyword ‘keyword’ appears.� As an aid to the programmer, a partial list of valid tokens is provided in SQLERRM as ‘token-list’.� 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 indicated keyword.� A colon or SQL delimiter may be missing. Verify that the clauses are in the correct order. If the reserved word that is identified in the messages is listed as a reserved word, make the word a delimited identifier.
