Search found 17 matches
- Wed Nov 12, 2014 12:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Deadlock occurs while updating SQL Server table in datastage
- Replies: 5
- Views: 4851
- Wed Nov 12, 2014 12:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Deadlock occurs while updating SQL Server table in datastage
- Replies: 5
- Views: 4851
- Thu Nov 06, 2014 3:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Deadlock occurs while updating SQL Server table in datastage
- Replies: 5
- Views: 4851
Deadlock occurs while updating SQL Server table in datastage
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...
- Sun Nov 02, 2014 10:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parsing large xml files (more than 10 mb)
- Replies: 3
- Views: 2968
Thanks
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.
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.
- Thu Oct 30, 2014 4:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parsing large xml files (more than 10 mb)
- Replies: 3
- Views: 2968
Parsing large xml files (more than 10 mb)
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)...
- Mon Aug 25, 2014 4:30 am
- Forum: General
- Topic: Web Service Jobs Import doubt
- Replies: 2
- Views: 1799
Web Service Jobs Import doubt
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...
- Wed Jun 11, 2014 3:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML stage Error due to special character
- Replies: 7
- Views: 3624
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...
- Mon Jun 09, 2014 11:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Replace a string with another string
- Replies: 12
- Views: 8352
- Mon Jun 09, 2014 7:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Replace a string with another string
- Replies: 12
- Views: 8352
- Mon Jun 09, 2014 7:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Replace a string with another string
- Replies: 12
- Views: 8352
- Mon Jun 09, 2014 6:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Replace a string with another string
- Replies: 12
- Views: 8352
Replace a string with another string
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...
- Thu Jun 05, 2014 4:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML stage Error due to special character
- Replies: 7
- Views: 3624
- Wed Jun 04, 2014 11:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML stage Error due to special character
- Replies: 7
- Views: 3624
Re: XML stage Error due to special character
Hi,
Any solution to the above mentioned problem? Please reply.
Any solution to the above mentioned problem? Please reply.
- Wed Jun 04, 2014 6:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML stage Error due to special character
- Replies: 7
- Views: 3624
XML stage Error due to special character
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...
- Tue Mar 25, 2014 4:56 am
- Forum: General
- Topic: Getting permission denied while trying to drop a table
- Replies: 1
- Views: 1462
Getting permission denied while trying to drop a table
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...