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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
You posted in the JCL forum...
what <language> is your <query> written in ?
it does not certainly look like SQL |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
But its not working. |
I believe we already understood that it didn't work. Posting "it didn't work" is just a waste of everyone's time.
If you would like someone here to help, you have to post what you used (actual jcl and control statements) and what diagnostic information was generated.
Seeing these, someone may have a suggestion. When posting jcl, code, control statements, etc, it is best to use the "Code" tag to preserve alignment and improve readability. |
|
Back to top |
|
|
|