View previous topic :: View next topic
|
Author |
Message |
Sriram K
New User
Joined: 17 Feb 2009 Posts: 32 Location: Bangalore
|
|
|
|
I want to replace the particular position of a table variable(abc_var) with some value for which i used the below query.
UPDATE
table1
SET abc_table =
REPLACE (abc_var,1,3,BOX)
WHERE
abc_id = '400'
;
But its not working. I'm not sure about the syntax as well. Can anyone suggest on this. |
|
Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
You can not update part of a column in DB2. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
Back to top |
|
|
|