SQL Query complex WHERE condition you need to modify a row

SQL update clause in a Query is to update a row which is already present in a Table. When you try to update a row and the condition in where clause is not matched, then DB2 returns +100 SQL code.

+100 SQL Code

+100 ROW NOT FOUND FOR FETCH, UPDATE OR DELETE, OR THE RESULT OF A QUERY IS AN EMPTY TABLE.

DB2 UPDATE SQL Query examples

DB2 UPDATE SQL Query with examples. You can update multiple rows.

Example SQL

UPDATE Emp_Table SET Last_Name = 'Srini',
Dept_No = 100,
Salary = 81000
WHERE Employee_No = 123456 ;

When the condition in “WHERE” clause matches, it will modify the row. Else, you will get +100 SQL code.

In SQL when you use SELECT then you need to have FROM clause. This combination is called SELECT – FROMSQL SELECT and UPDATE

Complex Condition in UPDATE

UPDATE Empl_Table
SET Salary = 88000
WHERE Last_Name = 'Srini'
AND First_Name = 'mf' ;

In “WHERE” clause you have two conditions. If matches, it will modify the row. Else, it will not modify it.

UPDATE Query more than 1 Table

UPDATE    Emp_Table
SET Salary = 79000
WHERE Employee_No IN     (SELECT Employee_No    
FROM Dept_Table    
WHERE dept_no is null) ;

Two tables are using for a matching condition. One is ‘EMP_TABLE’ and the other one is ‘DEPT_TABLE’. When the condition matches, it modifies that particular row.

Advertisements

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.