Accessing Auxiliary Storage: FILE › DB2 and SQL/DS Databases › FILE Functions for DB2 and SQL/DS Databases › Confirm Changes

Confirm Changes

When you instruct FILE to update a column, or delete or insert a row, FILE displays the following screen:

                         CA InterTest    File DB2 Facility
 EXEC SQL                                     
 UPDATE DSN8130.TEMPL SET WORKDEPT='A15' WHERE EMPNO = '000010'          
 ---------------------------------------------------------------                                                                                         
 ---------------------------------------------------------------                                                                                 
                                                                                                
                                                                                            
                      SQLERRD(3)=  00000001 Records   Updated.                   
                 è  _ C =Commit  R =Rollback                                    
                                                                                                     
                                                                                                     
 _______________________________________________________________________________  
 1 Help       2 CMND list 3 END       4 Large CMND  5 Log On      6 DataType FC 
 7            8           9           10            11           12

You must enter either a C or R.

• Enter C to confirm that the change is to be executed. FILE executes the change and indicates that the command has been successfully executed.
• Enter R to cancel the change.