Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

EXECUTE MULTIPLE UPDATE STATEMENTS

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
i.see.the.truth

New User


Joined: 21 Sep 2007
Posts: 8
Location: CHENNAI

PostPosted: Mon Sep 17, 2012 6:15 pm    Post subject: EXECUTE MULTIPLE UPDATE STATEMENTS
Reply with quote

Hi,

I have the following update statements to be executed with the below mentioned condition. Is there any DB2 function that can achieve the same result.

Statement 1 -

UPDATE TABLE_1
SET COLUMN_1 = 'VAL1'
WHERE COLUMN_3 = 1

Statement 2 -

UPDATE TABLE_1
SET COLUMN_2 = 'VAL2'
WHERE COLUMN_3 = 2

Condition -

Statement 2 should be executed when no rows are updated by Statement 1. Is there any way this can be done using SQL only?
Back to top
View user's profile Send private message

Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Mon Sep 17, 2012 7:50 pm    Post subject:
Reply with quote

Untested:
Code:
UPDATE TABLE_1
SET COLUMN_1 =
CASE
    WHEN COLUMN_3 = 1 THEN 'VAL1'
    WHEN COLUMN_3 = 2 THEN 'VAL2'
END


Can COLUMN_1 be NULL? If not, you'll run in to the 'error' with above SQL.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Mon Sep 17, 2012 8:11 pm    Post subject:
Reply with quote

Quote:
Statement 2 should be executed when no rows are updated by Statement 1.


i would interpret this to mean if the UPDATE ...WHERE COLUMN_3 = 1
returns an sqlcode of +100 or sqlerrcd(3) = 0
then update WHERE COLUMN_3 = 2
Back to top
View user's profile Send private message
i.see.the.truth

New User


Joined: 21 Sep 2007
Posts: 8
Location: CHENNAI

PostPosted: Tue Sep 18, 2012 11:01 am    Post subject:
Reply with quote

Yes Dick Brenholtz, u r right, can this be done using SQL only, without using a programming language?

Thanks
Soumen
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts -913/-911 Deadlock during UPDATE stat... NoSleep319 DB2 5 Fri Nov 18, 2016 12:37 am
No new posts How to update a portion of text in a ... Bill Woodger DFSORT/ICETOOL 25 Wed Nov 09, 2016 9:41 pm
No new posts Updating Cursor row withour using FOR... chandan.inst DB2 15 Tue Nov 08, 2016 11:17 am
No new posts execute APP if they are not ADDRESS T... italo_pm CLIST & REXX 3 Fri Aug 12, 2016 2:15 am
No new posts Converting multiple VB files to FB fi... Viswanath Reddy JCL & VSAM 6 Mon Aug 08, 2016 11:49 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us