| Author |
Message
|
| team |
 Posted: Fri Nov 02, 2007 8:56 am Post subject: Escape Characters |
 |
|
Centurion
Joined: 03 Nov 2006
Posts: 108
|
I am trying to replace the presence of ' in XML data content with '.
How can I do this using the REPLACE esql funciton...i am not able to escape this. Any help would be great!
I have tried:
REPLACE(OutputRoot.MRM.MESSAGE,''',''');
REPLACE(OutputRoot.MRM.MESSAGE,''','\'');
REPLACE(OutputRoot.MRM.MESSAGE,''','''');
Thanks, |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Fri Nov 02, 2007 9:03 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You mean you're trying to make your data into invalid XML?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| kimbert |
| Posted: Fri Nov 02, 2007 3:51 pm Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
| Quote: |
| I am trying to replace the presence of ' in XML data content with '. |
That should not be necessary - the XMLNS and XMLNSC parsers will do that for you. What are you trying to do? |
|
| Back to top |
|
|
| Suresh Gupta |
| Posted: Fri Nov 02, 2007 8:47 pm Post subject: |
|
|
Apprentice
Joined: 29 Jun 2005
Posts: 46
Location: India
|
check this function " XML.AsisElementContent"
_________________
regards,
Suresh |
|
| Back to top |
|
|
| shalabh1976 |
| Posted: Mon Nov 05, 2007 7:12 am Post subject: |
|
|
Partisan
Joined: 18 Jul 2002
Posts: 381
Location: Gurgaon, India
|
But the XML domain should not be used.
However XMLNS.AsIsElementContent & XMLNSC.AsIsElementContent do not exist. 
XMLNS or XMLNSC is the correct and recommended one.
Or are you still on 2.1?
_________________
Shalabh
IBM Cert. WMB V6.0
IBM Cert. MQ V5.3 App. Prog.
IBM Cert. DB2 9 DB Associate |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon Nov 05, 2007 1:07 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
The XMLNS domain uses the XML constants, so XML.AsIsElementContent is (theoretically) valid for XMLNS.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
