View previous topic :: View next topic |
Author |
Message |
bullfighter Beginner
Joined: 15 Apr 2005 Posts: 26 Topics: 9
|
Posted: Tue Apr 19, 2005 5:04 pm Post subject: set null to a field |
|
|
hi,
I have a question on setting a Null to some of the fields in DB2. I have the below in my Easytrieve Program
SQL UPDATE AB.TABLE1
SET FIELD1 = :WS-VAR1
, FIELD2 = :WS-VAR2
, FIELD3 = :WS-VAR3
WHERE
< SOME CONDITIONS >
My question is, based on some conditions I need to set FIELD1 or FIELD2 as NULLs, how can I set NULLs to these FIELDS in my program
Thanks in advance |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12372 Topics: 75 Location: San Jose
|
Posted: Tue Apr 19, 2005 6:30 pm Post subject: |
|
|
Bullfighter,
It is very easy to update a column to null. Try this
Code: |
SQL UPDATE AB.TABLE1 +
SET FIELD1 = NULL +
,FIELD2 = NULL +
,FIELD3 = :WS-VAR3 +
WHERE < SOME CONDITIONS >
|
Hope this helps...
Cheers
Kolusu _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
|
|