DSXchange

Hi Kalpana, I am also new to this XML thing. But as far as my knowledge is concerned if you are selecting "XML Doc" in your input tab then while importing the XML file thru XML Metadata importer u need to select extra node(top of the column nodes) apart from the columns which stores xml do...

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 "...

XML input should have one input stage. if I remove this folder stage, job will throw an error.

or else can i replace this folder stage with any other stage?

rajesh

Thank you Arndw for providing information.

I checked my file with that of the link u provided. it says well formed.

So wht could be the error?


rajesh

I opend it in Internet Explorer. It seems fine.

How can I check whether the input XML is correctly formatted or not?

Thanks,
rajesh

The following is the error I am getting when I log the reject error:

"XML input document parsing failed. Reason: Xalan fatal error (publicId: , systemId: , line: 1, column: 1): Invalid document structure"

How could I solve this.

Thanks in Advance
rajesh

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: ...

Thank you Arnd,

I think u have given me a very useful information. may be this should solve my issue.

rajesh

ok.

but for this i should be aware of the repository file names and i should be knowing which file stores which kind of information.

Is there any doc/site available which stores this information?

Thanks,
rajesh

thank you Arnd for the information, I am able access 'localuv' thru Universe but nor thru ODBC. But i find no tables/ files when connected thru localuv. (Except <projectname>.example1 file) As these hashed files are DS repository files, i hope these store metadata. So my intension is to just retriev...

Or is it "uvodbc.config" file i need to configure inorder to access the DS repository files?

or else please let me know how can i access the DS repository files using Universe stage or hashed files stage?

Thanks in Advance
rajesh

Folks,

Inorder to access DS Repository Files thru Hashed files I think we need to configure UV.ACcount file on the server.

Is tht right?

If so, could you let me know how can I configure this file. When I try to open this its not in the readable format.

Help me out

Thanks in Advance
rajesh

Hi antonio, your SQl date format is MM/DD/YYYY HH:MI:SS. (Is wht stated by U) you are trying to convert that format to DD/MM/YYYY using ICONV & OConv. but the data stage default format is YYYY-MM-DD HH24: MI: SS so can you compre these 2 dates? reforamt your date and then compare. it shud work r...

Hi,

No need to follow the same convention. you can easily accomplish your task by the normal way instead of using a stored procedure.

As far as my knowledge is concerned, there is no problem in usign the stored procedures.

rajesh

Craig,

I did the same thing but the result i am getting for a sequentail file is '0' but for a database the result is correct.

Thanks ray for the info.

rajesh