DSXchange

Even after hash partitioning on the key, the deadlock still happens. So, please let me know what else can I do.

Do we have any other way to fix this issue? Because in sequential mode its taking too much time to execute in production.
Please let me know.

Hi, I am updating a SQL server table in datastage. I am getting the data from 2 different tables from target table. If the updation happens in parallel mode, I am experiencing a deadlock most of the times ("ODBC function "SQLExecute" reported: SQLSTATE = 40001: Native Error Code = 1,2...

Thanks a lot.
So, we should make it to a size which is more than the size of the size of the maximum size of an xml. But it has a limitation of 276 MB, I guess. Although I feel that should be enough in my case.

Hi, We are facing an issue with large xml sizes which are bigger tan 10 MB. We receive a SOAP response, in that response the actual content is embedded. Now we used the xml stage to parse the xml. Now we changed the value of apt_transport_block_size to 10 MB (which I understand is not good practice)...

Hi, We have a datastage job to call a web service. We used WSTrasnformerPX stage to call the web service where we are selecting the web service operation. If the WSDL address changes, we need to import the new WSDL definition and then make appropriate code change in the job. Do we have any other way...

The problem of parsing the special characters are resolved. We have changed the actual xml file to replace the special characters with their hex values. In this way I could parse the xml files. Now I am facing an issue to store the Trademark symbol in sql server database. I am not facing any issue w...

Thank you so much. I will try the basic transformer stage first. Do we have any disadvantages on that? I think it runs sequentially.

Thanks. I also feel so.
Do you have the BASIC code for erplace function for parallel jobs? Could you please share that?

Do we have any other work around using index, left, right? But probably in that case also, we will have to loop through.

Hi All, I have a requirement to replace a string with another string or just removing that string in datastage 8.5. And that string may appear more than once. Is there any function in DS 8.5 which does this? Please let me know. From this forum I got to know that we can write a routine to do this. Bu...

I did not mean that actually. Sorry if it means so.
But as I am stuck on this, I thought I would get reply from experts here in dsxchange.

Hi,
Any solution to the above mentioned problem? Please reply.

Hi, I am having the same issue with registered and trademark symbol as noted in this post. I am not being able to parse the xml file having those characters. Removing those characters will not help me as we need to store those values as well. I am using UTF-8 in the xml file as encoding scheme and n...

I am using NETEZZA as the database and using DATASTAGE VERSION8.5. While using the DRS_CONNECTOR stage in the BEFORE SQL we are writing a drop table command on a particular table.But when we are running the job we are getting error as "DROP TABLE PERMISSION DENIED". Although,we have permis...