Re: Help creating XML-Schema from iSeries PF

This link might be of help. I don't think there is a 'packed' scenario
in XML. 

 

http://www.w3.org/TR/xmlschema-2/#built-in-datatypes

 

 

-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx]
On Behalf Of Lilja, Bertil
Sent: Tuesday, October 24, 2006 9:58 AM
To: wdsci-l@xxxxxxxxxxxx
Subject: [WDSCI-L] Help creating XML-Schema from iSeries PF

 

All

 

I'm quite new to XML and maybe there is a chance that I do not fully
understand the way I am supposed to do this.

 

I have created a Connection in database explorer

Imported the table descriptions into a project in WDSC

 

Everything is Ok

 

Character fields in iSeries are defined as Character columns.

Packed fields in iSeries are defined as Decimal columns with correct
scale and precision.

Signed fields in iSeries are defined as Numeric columns with correct
scale and precision.

Text from DDS keyword COLHDG is retrieved and put as Comment on column
in WDSC.

 

I generate a XML-Schema and puts it in another project. When I generate
the schema I get following

 

Character field sample

        <xsd:element name="FIELD1">

          <xsd:simpleType>

            <xsd:restriction base="xsd:string">

              <xsd:length value="40"/>

            </xsd:restriction>

          </xsd:simpleType>

        </xsd:element>

 

Packed field sample

 

       <xsd:element name="FIELD2">

          <xsd:simpleType name="decimal">

            <xsd:restriction base="xsd:anySimpleType"/>

          </xsd:simpleType>

        </xsd:element>

 

Signed field sample

        <xsd:element name="FIELD3">

          <xsd:simpleType name="decimal">

            <xsd:restriction base="xsd:anySimpleType"/>

          </xsd:simpleType>

        </xsd:element>

 

Packed or signed filed gets the same type without any scale or precision

Comment on column is missing in the element description.

 

What can I do to get the missing parts into the XML-Schema?

 

Best regards and thanks in advance

/Bertil

 

Bertil Lilja

Information Specialist - AS/400 Sales & PM 

EMEA North Applications Delivery Unit 

EDS Sweden AB 

Kajskjul 107 A, Frihamnen

SE - 417 07 Goteborg, Sweden 

  

*  +46 (0)31 75 89022 / +46 (0)739 80 99 66  

* bertil.lilja@xxxxxxx   

EIM: bertil.lilja@xxxxxxxxxxx 

 

This email may contain information that is confidential and may be
privileged. Unless you are the intended addressee (or authorized to
receive for the addressee) you may not use, forward, copy or disclose to
anyone this email or any information contained in this email. If you
have received this email in error, please advise the sender by reply
email immediately and delete this email.