SQL errors

If an SQL error occurs while a statement is being run or explained, a panel is displayed containing the SQL error information.

To display the full text of the SQL statement that caused the error, press the SQL function key (F5) or enter SQL on the command line.

When you return from the error panel, FM/Db2 places the cursor on the failing statement or, if a syntax error occurred, places the cursor on the token in the failing statement that Db2® identified as in error. Statements that ran successfully before the failing statement are not rolled back, and no further statements are run or explained.