XML.GenerateComplexType

Generates an XML complex type for an output XML Schema document.

Syntax

INVOKE    XML.GenerateComplexType

WITH

SELECT    expression(s)

FROM      table     

Example

INVOKE     xml.GenerateComplexType

WITH

SELECT     destination, description

FROM       tour

This results in the following output:

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" targetNamespace="urn:USoft:Tours" xmlns:tns="urn:USoft:Tours">

<xsd:complexType name="ToursEx">

    <xsd:sequence>

    <xsd:element name="Tours" type="tns:Tours"></xsd:element>

    </xsd:sequence>

</xsd:complexType>

<xsd:complexType name="Tours">

    <xsd:sequence>

    <xsd:element minOccurs="0" maxOccurs="unbounded" name="TOUR" type="tns:TOUR"></xsd:element>

    </xsd:sequence>

    <xsd:attribute name="documentName" type="xsd:string"></xsd:attribute>

</xsd:complexType>

<xsd:complexType name="TOUR">

    <xsd:attribute name="DESTINATION" type="xsd:string" use="required"></xsd:attribute>

    <xsd:attribute name="DESCRIPTION" type="xsd:string"></xsd:attribute>

</xsd:complexType>

</xsd:schema>

The Tours complex type can be used as XML Data Type for the output parameter of a document oriented web service that uses SQL statement:

INVOKE     XML.Export WITH

SELECT     destination

,          description

FROM       tour

WHERE     ...