dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
You want something like
| Code: |
EXEC SQL
UPDATE EMPLOYEE
SET PHONENO='NONUM' WHERE PHONENO IS NULL;
END;
|
which was in another DB2 topic.
You need to change the table name, column name and "where" value to meet your requirement.
If you Search before posting, you will often find a useful answer very quickly and not need to wait for a reply. |
|
