Focal Point
[SOLVED] XML synonym creation in procedure

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8887079106

April 12, 2011, 12:10 AM
Devi C
[SOLVED] XML synonym creation in procedure
Hi,

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.

Thank you,
Devi C

This message has been edited. Last edited by: Kerry,


WebFOCUS 7.6.4,7.6.9
OS: Windows XP
HTML,EXCEL,PDF
April 12, 2011, 04:50 PM
Clif
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


N/A
April 18, 2011, 12:48 AM
C Devi
Hi Cliff,

Thanks a lot.
Sorry for the late reply.

Thank you,
Devi C


WebFOCUS 7.6.4 , 7.6.9
Windows
Excel, PDF, HTML