When you start a Table Editor session, you can specify whether you want to save each addition or change in the database as you make it, or whether you want to hold all your additions or changes and save them when you end the Table Editor session.
You specify when you want to save additions or changes by using the SAVE keyword when you type the EDIT TABLE command that begins a Table Editor session.
If you want to save additions or changes as you make them, use SAVE=IMMEDIATE. This option is only available if your database management system supports CURSOR HOLD. See your QMF administrator to find out if you can use the SAVE=IMMEDIATE option.
If you want to hold additions or changes and save them at the end of the Table Editor session, use SAVE=END. Because SAVE=END is the default for the EDIT TABLE command, you do not have to type anything if you want to hold additions or changes.
You will see examples of how to enter the EDIT TABLE command in the sections that follow.
If you specified that you want to see confirmation panels (CONFIRM=YES) either in your QMF user profile or when you began this Table Editor session, you'll see different confirmation panels depending on when you decide to save the data.