DB2 Server for VSE & VM: Interactive SQL Guide and Reference

SAVE



>>-SAVE--------------------------------------------------------><
 

SAVE is an ISQL command that is only meaningful while using the INPUT command with AUTOCOMMIT on. If AUTOCOMMIT is on, it saves all changes made since the last SAVE command or since the start of the INPUT command if no SAVE command has been typed.

SAVE has no effect with AUTOCOMMIT off. With AUTOCOMMIT off, a COMMIT is necessary to save all input. This also commits all changes made during the current logical unit of work. The COMMIT must be typed after the INPUT command is ended.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]