DSXchange

Hi..am doing a job that contains an external source stage, an xml input stage and a sequential file stage. My objective is to read an xml using external source stage , parse the read xml using xml input stage and finally write the parsed xml attributes to a sequential file. I have been able to read ...

Even we faced the same issue in our project. In the scenario that you mentioned above if the job will not successfully completes then this NZCC_* tables will remain in the DB. As a workaround we created temporary work table for each table , and selected the option 'Temporary Work Table mode as exist...

Hi Rodriguez, Thanks for your response. We are trying to clear the messages put in the queue by datastage only and not trying to clear the messages from any other application. Has it needs to be cleared from queue level or setting the expiry time in datastage will automatically clear the messages in...

Hi Rodriguez,

Thank you for your response.

We could see an expiry time option in MQ Connector(in header properties while it is used as a target).

Please let us know whether we can use this property to set the expiry time.

Thanks,
Mani

Hi, We have a job to write request string to a Message Queue Request Queue.Our job design is given below Oracle Connector ----->Transformer------>MQConnector We have to cleanse around 300000 records and we are passing 10 records at a time to queue in a loop (loop logic is written in sequence).But af...

Hi Ray,
We are using NLS_CHARACTERSET=AL32UTF8 at the source(Oracle DB)

Hi We have a job in which we are using MQConnector Stage to access a message queue and we have been provided with seperate queue for request and response. We are able to get responses for requests.But we are not able to detect the corresponding response for a request.We have seen a property called C...

Thank you Ernie,qt_ky and Ray for the suggestions.

We will work on it and let you know

Thank You Paul.

We have incorporated the suggestions that you have mentioned.It has worked :D

we changed the permission levels...still it's not working

We tried with the above suggestion ,but still we are facing the same issue.

Please find the permission on dsjob file
-rwxr-xr-- 1 dsadm dstage

Thanks,
Mani

Thank you all for the suggestions. Please find the script that we are using #!/bin/bash . /opt/IBM/InformationServer/Server/DSEngine/dsenv cd / cd /opt/IBM/InformationServer/Server/DSEngine/bin/ pwd . dsjob -run TEST TEST Since our login ID's doesn't belong to dsadm group , we are executing the scri...

Thanks arvind. but we did that already..still the same error

We are trying to invoke a job using dsjob command inside a script. But we are getting the following error when we run the script.

line 9: .: ./dsjob: cannot execute binary file


Please help us.

Do we have to make a host entry for web service port address in datastage environment to resolve the time out issue?