DSXchange

Hi Ernie,
Thank you ... Right now it is working with a dummy root tag (/abc) .. I am calling an After job shell script to remove the additional tags ...

Thanks for your inputs ...Appreciate it.

Regards,
Adduri

Hi Ernie,
I gave / in description only ... i mistyped it.
In server version this used to work, not sure if it is not supported in PX edition.

Hi Ernie, Thanks a lot for your reply ... i tried your solution. I am really very close to finish line. I am getting a warning when i give '/' in the derivation line (without single quote) and due to this the files are not created Derivation rule "/" is invalid. Message = "Element or ...

Hi, Please help me with my requirement. We are getting an XML feed via MQ messages. At a time there can be many message each one is an XML file. We are able to process the MQ messages and write to Database. Now, We are asked to save a backup of the messages in UNIX server. Each message should be sav...

you can put the above command and call from a before/after stage routine

I think DCOUNT is simpler in this case ...
If you are using UNIX you can get it thru a small command.

awk -F'~' {print NF} abc.txt

where ~ is the delimiter.

Note:- This is just another way, no necessary a simpler way

Yes, the bin directory ":/opt/IBM/InformationServer/Server/DSComponents/bin" is included in the path.

Thank you. I currently opened a ticket with IBM support. They say a patch is required. We are still waiting for them to send the patch.

I will post any further updates.

Hi Ernie, Thanks for your response. The MQ Client was installed on the Datastage machine. You said, the client has to be configured.What do you mean by "configured"? The LIBPATH variable has the location of the MQ component. Apart from that, no seperate configuration was done. What else sh...

Hi All, We recently migrated to Datastage V8.1 from 7.5. There is a new requirement to read from MQ and process the XMLs. I went thru the pre-requisites for using MQ in the documentation. We have the MQ Client installed on Datastage and the MQ Server we we are trying to connect is in the same networ...