-----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
Reading DataStage XML using VB.NET
Reading DataStage XML using VB.NET
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Reading DataStage XML using VB.NET
-----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
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
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.