Ending a File Manager/Db2 editor session

In View or Browse:

To end your FM/Db2 editor session:

Press the Exit function key (F3) or the Cancel function key (F12).

In Edit:

To end your FM/Db2 editor session and save any changes you have made:

Enter END on the command line, or press the Exit function key (F3).

To present the changes you have made to the current table to Db2® for validation, without ending the FM/Db2 editor session:

Use the SAVE primary command.

When you use the SAVE command, FM/Db2 processes any changes made one line at a time. Each change results in either an SQL INSERT, UPDATE or DELETE operation, Db2® may reject one of more of your changes. This is unlike an editor session of a normal data set, where generally all changes are made, or no changes are made.

Note the following about the SAVE process:

• FM/Db2 issues Db2® COMMIT points according to these commit options:
  • Commit when save issued
  • Commit when no save errors
  • Auto-commit count

  The settings for these options are either the global settings, or as specified for this FM/Db2 editor session only. The first two options influence whether a Db2® COMMIT is issued at the end of the SAVE process. The third option influences whether Db2® COMMIT points are issued during the SAVE process.

• Issuing a Db2® COMMIT finalizes all pending changes to the data, and is an irrevocable process. After the COMMIT is issued, you can cancel the editor session; however, any changes made since the start of the edit session are not backed out. Conversely, if no COMMIT has been issued, you can back out all changes made during the current editor session, regardless of how many SAVE commands have been issued.
• When the editor is operating in "large mode", any automatic Db2® COMMIT is disabled. Your changes are still presented to Db2® and validated; however, the final COMMIT is deferred until you end the editor session.

To end your FM/Db2 editor session without saving your changes (that is, since the previous successful commit point):

Enter CANCEL (or CAN) on the command line, or press the Cancel function key (F12). If you have made any changes to the data, FM/Db2 displays a message box asking you to confirm that you want to discard the changes.

Related tasks

• Editing related tables
• Specifying the editor session mode: "normal mode" or "large mode"

Related references

• CANCEL primary command
• SAVE primary command
• Editor Options (6 of 8) panel