View previous topic :: View next topic
|
Author |
Message |
janmejay Warnings : 1 New User
Joined: 22 Jun 2007 Posts: 85 Location: bangalore
|
|
|
|
i need to update a db2 table , below is the requirement
all the phone nos. in a phone_no field which is the key field should be updated with a prefix of 2. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Unload the table.
Adjust the phone number per the requirement.
Re-load the table.
You need a backup anyway. . . |
|
Back to top |
|
|
Aaru
Senior Member
Joined: 03 Jul 2007 Posts: 1287 Location: Chennai, India
|
|
|
|
Jan,
Search this forum for the LOAD/UNLOAD utilities. |
|
Back to top |
|
|
|