SQL BASIC

DB2 SQL 103 DML : UPDATE


DB2 SQL has given 2 options for SQL UPDATE statement:

  1. UPDATE using individual value
    UPDATE EMPLOYEE SET WORKDEPT = ’D11’, PHONENO = ’7213’, JOB = ’DESIGNER’ WHERE EMPNO = ’000270’
  2. UPDATE using SET of Values
    UPDATE EMPLOYEE SET (WORKDEPT, PHONENO, JOB) = (’D11’, ’7213’, ’DESIGNER’) WHERE EMPNO = ’000270’

IBM i developer.

View Comments
There are currently no comments.