DSXchange

<?xml version="1.0" encoding="UTF-8" ?> <wwprttxnresponse type="price" id="1000000" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="c:/WWPRT30/WwprtInterface/config/response.xsd"> <status>received</statu...

Xpath exprn : -


/wwprttxnresponse/@id
/wwprttxnresponse/@type
/wwprttxnresponse/status/text()

Hi all I am getting following waning message for XML out put stage in a server job ..... XML_Output_3: XML output document parsing failed. Column(0): "wwprttxnresponseXML" Reason: "Xalan error (publicId: , systemId: column[0] (wwprttxnresponseXML), line: 2, column: 48): Unknown elemen...

it is a parallel job actually we are supposed to get some xml msg over mq and are of two type say a and b which we need to find .. and according to type we have to process (different processing for diff. type) .... first i hve to parse it to chk any parsing error then i have sperate data according t...

Hi All Structure for XML parsing in my job is as folows MQ plugin----->XML i/p plugin------>transformer------>filter------>multiple xml i/p pugin I am getting XML over MQ then I have to parse the XML. This XML structure contains an attribute named type on the root element. In above job structure in ...

Hi I am facing a problem in IF condition while comparing the Hebrew data. In the Key Expression i am comparing value of input column 'MeoravStatus' If DSLink10.MeoravStatus = '?????' Then 'Cancelled' Else 'Active' the value is coming from inputfile is in Hebrew i.e 'מבוטל' which is showing '?????' w...

Hi
what exactly validating xml in DataStage means?
How we can achieve this in DataStage[what exactly we hav to do in XML plugin validations?]?

No I am doing nothing with this...

Just some of friend asked me this question...

Hi
If I want to remove the last row from my input file then how can I implement in DS server job?
I want to remove row at runtime.

What are the Repository Tables in DataStage and which are they?

hi
we want to remove duplicate records from seq. file in server job
our server is windows os server.

please suggest how to do it?

hi
how to get the substring from string in DS PX?
there is substrings function in server jobs,is there any such function in parallel job?

Hi I would like to comapre three data file hvng following column <number><value1><value2> In three files I would like to check/compare for every matching number in three file both values value1 and value2 must be matched. so what would be the best way to implement it consider following schenarios ? ...

Thx all ppl...problem resolved now... :D

Hi Kuamr
just want to make sure....the solution provided you....Using the sort stage..
It assigns 1 to first occurance of key value and duplicate key values with 0 ?