SQL Statements › UPDATE › Positioned UPDATE › Example 2

Example 2

Increase the job code by 10 members in Department D11.

 EXEC SQL
      UPDATE CA.TEMPL
      SET JOBCODE = JOBCODE + 10
      WHERE WORKDEPT = 'D11'
 END-EXEC