ANL1027I UNNECESSARY USE OF SEMICOLON TO END QMF STATEMENT. CHARACTER IGNORED (SQLCODE +98) AND SQL PA CONTINUES.
Explanation
A QMF statement ended with a semicolon (;), which is not necessary under QMF. The Prepare routine issued the +98 error code, and SQL PA removed the semicolon and prepared the statement again automatically.
User response
None
One of the following unnumbered messages could occur in QMF:
- ONE OR MORE LIMITS EXCEEDED BY YOUR QUERY PER SQL PA GOVERNOR EXIT or ONE OR MORE
LIMITS EXCEEDED BY YOUR QUERY–ANL HAS TERM I/O ERROR.
Your query exceeded the installation coded limits for CPU. Written to the QMF log. You might be given the option to cancel this query before starting. Term I/O error if Db2® cannot ask you WOULD YOU LIKE SQL PA TO CANCEL THIS QUERY (Y/N)?
- YOUR QUERY HAS BEEN CANCELLED BY THE SQL PA GOVERNOR EXIT.
The SQL PA Governor can prevent queries from running. The installation might choose to enforce this option when installing ANLGOV1 or leave the decision to the user. In either case, run the query in Batch mode.