DSXchange

Posted: **Thu Nov 13, 2003 12:02 pm**

-----Original Message-----
From: Peter Nolan [mailto:pnolan@attglobal.net]
Sent: Friday, October 17, 2003 2:48 PM
To: datastage-users@oliver.com
Subject: Reading DataStage XML using VB.NET

Hi All,
I am writing an XML reader for exported datastage XML.

I am using the VB.NET DataSet class as below. When I try to read the XML
(as below) it fails and I get the message.

Additional information: The same table (Property) cannot be the child
table in two nested relations.

Can anyone enlighten me as to how I might read datastage XML using
VB.NET? Is there some DTD or something else I need to make VB.NET read
DS XML?

Any and all help much appreciated.

Best Regards

Peter Nolan
www.peternolan.com

Dim XmlSchema11 As New DataSet("XmlSchema11")
Dim FS As Stream

FS = New FileStream("D:\temp\testxml1.xml", FileMode.Open)
XmlSchema11.Clear()
XmlSchema11.ReadXml(FS)

Imported from:
BILLDEVSTAGEORA92 / ODSDEV.HLP_DIM_KEYS (as seen from infradata) -
30/08/2003 12:42:12
Type: TABLE
Owner: ODSDEV
Fully-qualified name: "ODSDEV"."HLP_DIM_KEYS"
Unqualified name: HLP_DIM_KEYS
8
MS1252
"
0
;

DIM_KEY_INT
<none>
Searchable? N\(20)
3
19
0
0
0
21

quote=none

DIM_CHAR_KEY_FLD
<none>
Searchable? N\(20)
12
255
0
0
1
255

,
"
0
0
0
0
0
TableType="ODBC
3.0"|Computer="US.ORACLE.COM"|SoftwareProduct="Oracl
e"|DataStore(Database
Link)="BILLODS"|DataSchema(Owner)="ODSDEV"|DataColle
ction(Table)="HLP_DIM_KEYS"
ODSDEV

record_delim='\n',
delim=',', final_delim=end, quote=double

Posted: **Thu Nov 13, 2003 12:02 pm**

-----Original Message-----
From: ernie.ostic@ascentialsoftware.com
[mailto:ernie.ostic@ascentialsoftware.com]
Sent: Monday, October 20, 2003 8:22 AM
To: datastage-users@oliver.com
Subject: RE: Reading DataStage XML using VB.NET

Very interesting... have you tried reading it with pure DataStage? Having
duplicate element names at various sub-element levels is perfectly valid XML
design....they are unique by the path (their parentage). VB shouldn't be
complaining....

Ernie

-----Original Message-----
From: Peter Nolan [mailto:pnolan@attglobal.net]
Sent: Friday, October 17, 2003 3:48 PM
To: datastage-users@oliver.com
Subject: Reading DataStage XML using VB.NET

Hi All,
I am writing an XML reader for exported datastage XML.

I am using the VB.NET DataSet class as below. When I try to read the XML
(as below) it fails and I get the message.

Additional information: The same table (Property) cannot be the child
table in two nested relations.

Can anyone enlighten me as to how I might read datastage XML using
VB.NET? Is there some DTD or something else I need to make VB.NET read
DS XML?

Any and all help much appreciated.

Best Regards

Peter Nolan
www.peternolan.com

Dim XmlSchema11 As New DataSet("XmlSchema11")
Dim FS As Stream

FS = New FileStream("D:\temp\testxml1.xml", FileMode.Open)
XmlSchema11.Clear()
XmlSchema11.ReadXml(FS)

Imported from:
BILLDEVSTAGEORA92 / ODSDEV.HLP_DIM_KEYS (as seen from infradata) -
30/08/2003 12:42:12
Type: TABLE
Owner: ODSDEV
Fully-qualified name: "ODSDEV"."HLP_DIM_KEYS"
Unqualified name: HLP_DIM_KEYS
8
MS1252
"
0
;

DIM_KEY_INT
<none>
Searchable? N\(20)
3
19
0
0
0
21

quote=none

DIM_CHAR_KEY_FLD
<none>
Searchable? N\(20)
12
255
0
0
1
255

,
"
0
0
0
0
0
TableType="ODBC
3.0"|Computer="US.ORACLE.COM"|SoftwareProduct="Oracl
e"|DataStore(Database
Link)="BILLODS"|DataSchema(Owner)="ODSDEV"|DataColle
ction(Table)="HLP_DIM_KEYS"
ODSDEV

record_delim='\n',
delim=',', final_delim=end, quote=double