Accessing Auxiliary Storage: FILE › DB2 and SQL/DS Databases › Redisplay SQL Commands

Redisplay SQL Commands

To redisplay the last six commands you have entered, press PF2. Then select any command to re-execute or modify. The following screen shows a command list.

• Enter x in the field to the left of a command to execute it
• Enter m to modify a command
• If you do not enter any data, any PF key returns you to either the table data display or structured display

                       CA InterTest   File DB2 Facility                        
                                                                                
 SQL  Command List           X  to execute     M  to modify the command         
                                                                                
 _  UPDATE DSN8130.TEMPL SET WORKDEPT='A15' WHERE EMPNO = '000010'              
                                                                                
                                                                                
 _  DELETE FROM DSN8130.TEMPL WHERE WORKDEPT = 'D11'                            
                                                                                
                                                                                
 _  INSERT INTO DSN8130.TEMPL (EMPNO,FIRSTNME,MIDINIT,LASTNAME,WORKDEPT,SALARY) 
    VALUES('010200','JAMES','S','NEWMAN','D11',27500)                             
                                                                                
 _  SELECT * FROM DSN8130.TEMPL