|
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: 6965
Location: porcelain throne
|
|
| Back to top |
|
|
|
|
