SQL Statements › UPDATE › Positioned UPDATE › Example 1

Example 1

For employee 000190, change the employee's telephone number in the TEMPL table.

 EXEC SQL
      UPDATE CA.TEMPL
      SET PHONENO = '3565'
      WHERE EMPNO = '000190'
 END-EXEC