RE: Multiple condition sql

Something like this will update all three fields on all records. If the flag isn't set that field is updated with the same value:

update contract_file
Set emp = case when empflag = 'Y'
then newUser
else emp
end,
contact1 = case when contflag1 = 'Y'
then newUser
else contact1
end,
contact2 = case when contflag2 = 'Y'
then newUser
else contact2
end

Paul Morgan

Principal Programmer Analyst
IS Supply Chain/Replenishment


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Smith, Mike
Sent: Wednesday, August 18, 2010 1:37 PM
To: Midrange Systems Technical Discussion
Subject: Multiple condition sql

I'm trying to figure out if the following 3 sql statements can be
combined into 1 statement.

I'm trying to update 1 file and set specific field based on flagged
variables from a display file.

Update contract_file set emp = newUser where empflag = 'Y'
Update contract_file set contact1 = newUser where contflag1 = 'Y'
Update contract_file set contact2 = newUser where contflag2 = 'Y'

Thanks

Mike



NOTICE: This message, including any attachment, is intended as a confidential and privileged communication. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender and delete this message.