Re: How do you read an XML schema in SQL 2005

"Dee" <Dee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:55FB83CE-EF1C-4DE4-A19B-176C86007D3B@xxxxxxxxxxxxxxxx
From what I see my source may already be in a schema collection. If so is
there doc on getting the information in the database? Here is a sample of
what I have:


<?xml version="1.0" encoding="UTF-8"?>
<!-- edited with XMLSpy v2008 (http://www.altova.com) by United Stationers
Supply Co. (United Stationers Supply Co.) -->
<!--

** OAGIS® Revision: 9.0 **
** Date: 08 April 2005 **
** Copyright 1998-2005, All Rights Reserved **

This is an OAGIS® BOD XML Schema (XSD) Definition.

License information for this file is provided in the file **2005 OAGi
License Agreement.txt** that is provided with this download package.

For support, more information, or to report implementation bugs, please
contact the Open Applications Group at xml@xxxxxxxxxxxxxxxxxxxxx

XML Schema

Name:
-->
<xsd:schema xmlns:oa="http://www.openapplications.org/oagis/9";
xmlns:xsd="http://www.w3.org/2001/XMLSchema";
xmlns:us="http://www.ussco.com/oagis/0";
targetNamespace="http://www.ussco.com/oagis/0";
elementFormDefault="qualified"
attributeFormDefault="unqualified">
<xsd:import namespace="http://www.openapplications.org/oagis/9";
schemaLocation="..\..\..\OAGIS-9_1-GA-070511-Schemas\oagis\9_1\Resources\Nouns\ItemMaster.xsd"/>
<xsd:include schemaLocation="..\Components\Common\Components.xsd"/>
<xsd:complexType name="ItemMasterType">
<xsd:sequence>
<xsd:element ref="us:ItemMasterHeader" minOccurs="0"/>
<xsd:element ref="us:ItemLocation" minOccurs="0" maxOccurs="unbounded"/>
<xsd:element ref="us:GlobalItem" minOccurs="0" maxOccurs="unbounded"/>
<xsd:element ref="us:ReferenceItem" minOccurs="0" maxOccurs="unbounded"/>
<xsd:element ref="us:ConsumerPricing" minOccurs="0"/>
<xsd:element ref="us:ItemList" minOccurs="0" maxOccurs="unbounded"/>
<xsd:element ref="us:Matchbook" minOccurs="0" maxOccurs="unbounded"/>
<xsd:element ref="us:WarrantyInfo" minOccurs="0"/>
<xsd:element ref="us:LineDrawing" minOccurs="0" maxOccurs="unbounded"/>
</xsd:sequence>
</xsd:complexType>
<xsd:element name="ItemMaster" type="us:ItemMasterType"/>
<xsd:complexType name="GlobalItemType">
<xsd:sequence>
<xsd:element name="StartDate" type="oa:DateTimeType" minOccurs="0"/>
<xsd:element name="EndDate" type="oa:DateTimeType" minOccurs="0"/>
<xsd:element name="UprIncludeCode" type="oa:CodesType" minOccurs="0"/>
<xsd:element name="InventoryUnitCode" type="oa:UOMCodeType" minOccurs="0">
<xsd:annotation>
<xsd:documentation>USSCO: Unitedâ?Ts inventory selling unit of measure.
</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="ItemWeight" type="oa:MeasureType" minOccurs="0">
<xsd:annotation>
<xsd:documentation>USSCO: The item weight based on the selling unit of
measure. Weight values are reflected in single numbers in pounds with 3
decimal places to the right (x.xxx). Refer to the SHP_WGT_QTY for the
master
carton weight. Note: The item weight has been provided fo
</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="GTINItem" minOccurs="0">
<xsd:annotation>
<xsd:documentation>USSCO: Used to identify trade items at various
packaging levels (item level)
</xsd:documentation>

Thank you
Dee


What is your 'source'?
The code above is a schema, is this schema already part of an XML SCHEMA
COLLECTION?
Do you have any XML instances that you wish to validate or store that
conform to this schema?
What exactly do you want to do?

--

Joe Fawcett (MVP - XML)

http://joe.fawcett.name


.

Loading