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

Example

To change the WORKDEPT column for an employee, specify the following, and then press Enter:

UPDATE DSN8130.TEMPL SET WORKDEPT = `A15' WHERE EMPNO = `000010'

This command instructs FILE to change the WORKDEPT column in table DSN8130.TEMPL for the employee whose EMPNO is 000010.

Before performing the update, you are asked to confirm the change. For details, see Confirm Changes later in this chapter.