DSXchange

Hi James

Thanks for the link.

chulett wrote:Why do you asK?

Thanks.
So after a row is written out the stage variable is empty or does it hold the earlier value?

Trying to have a better understanding of stage variables so asked.

Hi,

Are stage variables reset to initial value as defined in stage variable property after each row is written out or it holds the value from the processing even after the row is written out?


Thanks.
Chetan

Hi ,

Finally succeded in developing the code for the job.
It is working perfectly.

A big thanks to Kandy .

Ray,craig,Muni shekar

Thanks for all the inputs.

Will be posting the entire code here shortly.

Thanks again,
Chetan.C

Hi kandy,
Can you please paste some sample code for this?
I'm trying but getting confused on the way stage variables are working.


Thanks.

Chetan, So did you get what you wanted? hi kandy, Thanks for the help with the logic and implementation!! Really appreciate you response. Currently i am stuck in the last part where in the XML data is in different rows. As ray suggested i have to write the XML once the closing tag(</Request>) has b...

The logic is correct, and you can accumulate the XML as a single string in a stage variable. Output it once the closing tag has been processed (that is, if the input value is "</Request>"). ... Hi Ray, I have been trying to read as much as possible on stage variables. Can you please let m...

That sounds like a good start. Now that we know you want to store rather than parse it, can you tell us what 'store' means here? Where / how does it need to be stored? Hi Craig, Actually i have to parse it and also store it. By parsing i will be getting values from the XML which along with the fiel...

<Request> <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"> <SOAP-ENV:Header> <mes:MessageHeader xmlns:mes="http://csi.cingular.com/CSI/Namespaces/Types/Public/MessageHeader.xsd"><mes:TrackingMessageHeader><cin:version xmlns:cin="http://csi.cingu...

XML messages can be read similar to how you read normal lines.. If it is complex, try using index and field functions to get what you want.[/quote] I have experimented with the XML input stage and am able to read an XML document. But the problem is how to get only the XML part that is from its start...

Also is there a way where i can extract the entire XML and pass it to the XML input stage itself and extract values from there?

Hi Kandy,

The job is working fine and as required for the data apart from the XML content. .
The part of getting the coulmn names was excellent.

But can you guide me on how to read the XML messages?.
As i'm not getting the logic for XML content in the stage variables.


Thanks!!

Hi Kandy,

Developing the job ,will get back with the results.
Thanks for the explanation.


Thanks.

Yes they are similar.
I want to process all the files at once.

Thanks for your time.

Little difficult to understand the actual requirements. Can you post one file content and tell us what you want? File1 StatusCode=500 StatusCodeText=Internal Server Error RequestHeaderSize=221 RequestDataSize=1696 RequestSize=1917 ResponseHeaderSize=167 ResponseDataSize=3997 ResponseSize=4164 [urlf...