Online Documentation for SQL Manager for DB2

Compile window


The Compile window is used to trace the errors and edit SQL statements during their compilation. The compilation window appears each time metadata is changed, both when the compilation is successful and when there are compilation errors.

 

Comment for Version Control

This box is available only if the Version Control system is enabled. Here you can leave a message about the object modification.

 

Statement sequence

This area contains the list of operations and the result of their parsing (successful or error).

 

Selected statement

This area displays the SQL statement pending to be executed to perform metadata changing. In this area you can view and edit the SQL statement.

In case of a compilation error the Error tab also becomes visible - here you can view the error description returned by the server.

 

Commit

This button starts execution of the statement(s). Click it to commit the current transaction. This button is available only if there were no errors in compilation.

 

Rollback

This button cancels the script execution and allows you to return to the previous stage (editor window or DB Explorer).

 

Rollback and Recompile

This button calls for recompilation with the changes you made in the Selected statement editing area. Use this button after correcting the SQL statement.

 

Appendix - Changing Metadata window

 

 

If necessary, you can copy information to clipboard and save it in a text editor afterwards (the button is only enabled when a compilation error occurs).