Creating a nickname for remote XML data - examples

To work with remote XML data, you need to create a nickname for a remote table that contains XML data or for an XML document.

Example: Create a relational nickname that corresponds to a remote table named XMLTABLE1. Table XMLTABLE1 contains column XMLCOL that is defined with the XML data type:

CREATE NICKNAME NNXML1 FOR SERVER1.SCHEMA1.XMLTABLE1;

Example: Create a non-relational nickname for an XML document by using the XML wrapper:

CREATE NICKNAME NNXML2
  	(file_path VARCHAR(64) OPTIONS(DOCUMENT 'FILE'),
  doc XML)
FOR SERVER XML_SERVER;