DSXchange

Have you tried with @OUTROWNUM. Because I had a similar issue and I used @OUTROWNUM to solve the problem.

Can you please make sure "D:/tar/xml/" is a valid path. This path represent the Server Machine NOT your client.
- U

Hi, I tried that option as well. Here is the error I got; TestValidateXSD..XML_Input_1: XML input document parsing failed. Reason: Xalan fatal error (publicId: , systemId: , line: 1, column: 39): An exception occurred! Type:TranscodingException, Message:An invalid multi-byte source text sequence was...

Can you please double check the properties of your Folder Stage; Stage->Properties->Folder PathName : Defined the folder where you could find the xml. e.g C:\MyFiles\XML Outputs->Properties->WildCard : Mention your xml document. e.g MyFile.xml In the XML Input Stage->Input -> XML Source Column : Sel...

Hi, I'm trying to validate XML document against it's defined rules. Here is the job layout. Folder ---> XML Input ---> Seq File. I've tried with Validate XML input (General/Strict) but didn't get the results. I've tried with Log rejected Error option. Didn't get the expected results. Then I went thr...

First use the DataStage Manager to Load the meta data. Manager -> Import - > Table def - > XML TAble DEf Then Open your XML . File -> Open Then click on all text nodes which you want and save the meta data. Now goback to your job, open XML Input stage, then output tab , columns, Load. Then Load the ...

Use the following stages. Folder ---> XML Input ---> Transformer ----> SEQ file. Whatever columns comes out from XMLInput should pass-through the Transformer stage. In the transformer you might have to convert some invisible characters as follows. ereplace(ereplace(xmlOP.Column1, char(10) , "&q...

If you change the unix scripts as follows, you may not seen any duplicates

sort myfile.txt | awk '{print $1}' | uniq

Hi, I'm going to read a repeated xml hierarchy and extract some key column to a flat file. It always output the first row ?? I guess we need to XSLT or DTD before hand we read the xml file. Please let me know if you know anything about this problem. Thanks -U Here is the sample input : Where LevelID...

Hi, I've read lot of posting about the above topic and couldn't find am answers for my questions. Does anybody knows how to 1. Make a batch file to execute a TCL commands 2. Which Repository tables should I query for information like [data stage ]job creaion date, last modified date and job logs. 3....