DSXchange

Thank you very much Arndw.
Iconv worked for my requirement.
thank you very much.

Hi All, I have a requirement to implement the query select trim( to_number(to_date(&1,'yyyymmdd') - to_date(&2,'yyyymmdd')) ) in a column of a datastage transformer stage. &1 and &2 are two columns in the transformenr input which are dates in "YYYYMMDD" format. the output s...

Thank you very much Mr. Robinson.
your inputs helped me in resolving my issue.
Thank you very much.

And thanks to you hulett.Thanks for your active participation

Hi all, I am working on XML input stage where I am facing problem with XML contexts. I am having a context like this <tId> <trId context="SUN/trId/0"> 59876543</trId> <trId context="SUN/transId/0">12345678</trId> <trId context="QUN/tradeId/0">1546382</trId> </tId> when ...

atlast I implemented the the conversion of XML file to CSV without a transformer.

need to incorporate business rules in the transformer.
Thanks all for ur valuable inputs.
:D

Hi craig, Thanks for the reply. :) I have found xml plugins in my DS. I tried using a folder stage as an input stage to XML input stage.but it is possible only in a server job. but our requirement is to use a parallel job. can anyone help me with the way we can feed an xml file to an XML input stage...

Hi,
We have a requirement for conversion of an XML file to a CSV file with some transformations in the middle .
I didn't find any file stages related to an xml file in my version of datastage(7.5.1A).
Can any body enlighten me about how it can be done.

Any kind of help is very much appreciated. :D