I like to have a procedure to create synonym for xml dynamically. I searched the forum and got the syntax for sql. I didn't find any documentation for this also. What is the syntax to create synonym for xml in a procedure? Please help me.
Devi CThis message has been edited. Last edited by: Kerry,
OS: Windows XP
It's easiest to do this from the Data Management Console or the Web Console because there are many options.
Here's a simple example using sample schema dmxord.xsd that describes dmxord.xml, both located in the ibisamp directory, creating a synonym there.
CREATE SYNONYM ibisamp/dmxord FOR dmxord.xsd DATABASE ibisamp/dmxord.xml DBMS XML AT ibisamp
Thanks a lot.
Sorry for the late reply.
WebFOCUS 7.6.4 , 7.6.9
Excel, PDF, HTML
|Powered by Social Strata|