Reg. XML Input
Moderators: chulett, rschirm, roy
Reg. XML Input
Folks,
I am working on XML input to load data from XML file to DB2.
I have gone thru the forum and got some information with that i did the job. I am successfull in compiling the job. But when I tryto run this its a success but i am not able to load data into the target table.
my job is as follows:
FOLDER--->XML INPUT---->DATABASE TABLE
I set the folder stage with only 2 columns as this is not accepting more than 2 and one of them is a key. and for this the NLS is set to NONE.
IN XML INPUT i am not validating the i/p XML file and loaded the name space decalration from table definitions of XML file.
I checked "Repitition Element Required" and set my key field.In advanced tab i have laoded the stylesheet thru URL/FilePath.
My database NLS is set to UTF-8(As specified in PDF)
when I run this i can c the reocrds are read from folder stage to XML input stage but 0 rows are instered from XML Input to DAtabase table.
Please help me out
Thanks in advance
rajesh
I am working on XML input to load data from XML file to DB2.
I have gone thru the forum and got some information with that i did the job. I am successfull in compiling the job. But when I tryto run this its a success but i am not able to load data into the target table.
my job is as follows:
FOLDER--->XML INPUT---->DATABASE TABLE
I set the folder stage with only 2 columns as this is not accepting more than 2 and one of them is a key. and for this the NLS is set to NONE.
IN XML INPUT i am not validating the i/p XML file and loaded the name space decalration from table definitions of XML file.
I checked "Repitition Element Required" and set my key field.In advanced tab i have laoded the stylesheet thru URL/FilePath.
My database NLS is set to UTF-8(As specified in PDF)
when I run this i can c the reocrds are read from folder stage to XML input stage but 0 rows are instered from XML Input to DAtabase table.
Please help me out
Thanks in advance
rajesh
Raj,
have you tried opening up the XML document in your xml-enable browser or by using one of the many structure-checking utilities available on the market to make sure that your document is well-formed?
have you tried opening up the XML document in your xml-enable browser or by using one of the many structure-checking utilities available on the market to make sure that your document is well-formed?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
There are so many ways available to check this. Try using this web page to cut-and-paste your XML to see if it is well-formed. I suspect that it isn't.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Can you try making a copy and changing the job to work without the folder stage and loading the one XML you already checked to see if the error remains?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 66
- Joined: Fri Nov 25, 2005 7:55 am
I would normally suggest just using a sequential file input. Can you post the first 10 lines or so of your XML?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
YEs Vijay I have imported my fileds using XML Metadata Importer only. While doing so I checked the text of the columns(LAst node of the tree).
Following is how i configured my XML INPUT Plugin
In XML Imput Stage:
IN STAGE TAB
GENERAL: Nothing has been checked.
TRANSFORMATION SETTINGS: CHECKED "REPITITION ELEMENT REQUIRED". CHECKED "INCLUDE NAMESPACE DECLARATION" and loaded information from table definitions.
IN INPUT TAB
XML SOURCE: selected on of the two columns in folder stage.
COLUMN CONTENT: "URL/FILE PATH"
IN OUTPUT TAB
GENERAL: Nothing has been checked
TRANSFORMATION SETTINGS: CHECKED"INHERIT STAGE PROPERTIES"
ADVANCED: NOTHING HAS BEEN CHECKED
COLUMNS: IMPORTED COLUMNS FROM TABLE DEFINITIONS
Thanks,
rajesh
Following is how i configured my XML INPUT Plugin
In XML Imput Stage:
IN STAGE TAB
GENERAL: Nothing has been checked.
TRANSFORMATION SETTINGS: CHECKED "REPITITION ELEMENT REQUIRED". CHECKED "INCLUDE NAMESPACE DECLARATION" and loaded information from table definitions.
IN INPUT TAB
XML SOURCE: selected on of the two columns in folder stage.
COLUMN CONTENT: "URL/FILE PATH"
IN OUTPUT TAB
GENERAL: Nothing has been checked
TRANSFORMATION SETTINGS: CHECKED"INHERIT STAGE PROPERTIES"
ADVANCED: NOTHING HAS BEEN CHECKED
COLUMNS: IMPORTED COLUMNS FROM TABLE DEFINITIONS
Thanks,
rajesh
Hi! Arnd
How should we configure the xml stage,if we use a sequential file instead of a folder stage.
assuming xml goes like this...
<?xml version="1.0" encoding="ISO-8859-1" ?>
- <messageListFromWcs xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="WcsToHost.xsd">
<datetime>2006-01-18T14:40:34</datetime>
<sequenceNo>00000598</sequenceNo>
- <purchaseOrdersToBW>
<extractDate>2006-01-18</extractDate>
<poNum>638508</poNum>
<poSplitNum>02</poSplitNum>
<sapDcSiteCode>D985</sapDcSiteCode>
<supplier>500362</supplier>
<orderDate>2006-01-18</orderDate> .......
Thanks
kalpna
How should we configure the xml stage,if we use a sequential file instead of a folder stage.
assuming xml goes like this...
<?xml version="1.0" encoding="ISO-8859-1" ?>
- <messageListFromWcs xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="WcsToHost.xsd">
<datetime>2006-01-18T14:40:34</datetime>
<sequenceNo>00000598</sequenceNo>
- <purchaseOrdersToBW>
<extractDate>2006-01-18</extractDate>
<poNum>638508</poNum>
<poSplitNum>02</poSplitNum>
<sapDcSiteCode>D985</sapDcSiteCode>
<supplier>500362</supplier>
<orderDate>2006-01-18</orderDate> .......
Thanks
kalpna