Deleting work buffer contents after execution

After you execute the statements or commands, you would normally delete them from the buffer. If the “Clear Work Buffers” option in your profile (see Window Parameter Display and Edit Window) is set to Yes, the contents is automatically deleted when the work buffer being displayed is ended. If it is set to No, you can use the CLEAR command followed by end. This ensures that the buffer contents are deleted after execution. The CANCEL command deletes only the most recently appended rows. CANCEL does not remove previously saved statements—only those statements appended since the last commit point created with the SAVE command or the END command.

To delete specific lines from the work buffer, use the D row command.

If you don’t delete the contents, you may unintentionally reexecute them. Make a habit of either deleting statements as they are executed, or always accumulating work buffer contents to be executed at one time.