DSXchange

Perhaps that's what I mean...I've only used this method using ODBC targeting a SQL Server db, but the option is available using any of the RDBMS types available in the DRS Stage. Maybe you get different results when using the native drivers vs. ODBC. I couldn't say...best for the op to test if they ...

While Craig's and Ray's methods are probably the best way to handle your situation, you could also use a DRS stage with an update action of 'Insert New Rows Only'. This will ignore any primary key violations and contiue processing without logging any warnings to the log. Edit:I know this can be acco...

I believe the Google Search SOAP API used in this example has been deprecated. Try a different service, perhaps from http://www.xmethods.net, and see if you get different results.

If you are on version 8 and it appear that you are, I believe the following envrionment variable should be present in dsenv, but perhaps it was added by our Admins: ASBHOME=/opt/IBM/InformationServer/ASBNode If not, either add the environment variable or just use the path the variable is set to abov...

We were getting the same error you are now getting PRIOR to the abnormal termination error. We were missing the DATASTAGE_JVM and DATASTAGE_JRE environment variables from dsenv. Once we added the variables we started receiving the abnormal termination errors. Once we made the noted adjustments provi...

We resolved the issues by verifying/modifying the following environment variables within dsenv: 1. Set DATASTAGE_JRE DATASTAGE_JRE=/opt/IBM/InformationServer/ASBNode/apps/jre 2. Set DATASTAGE_JVM DATASTAGE_JVM=bin/sovvm 3. Export DATASTAGE_JRE and DATASTAGE_JVM 4. Modify LIBPATH inside dsenv so that...

We encountered a similar if not the same issue when trying to use any of the web service stages avaiable within DataStage. We would just receive an abnormal termination message with no other supporting information. We resolved the issues by verifying/modifying the following environment variables wit...

I previously had a problem calling a web service through a web services transformer stage because the DATASTAGE_JRE and DATASTAGE_JVM environment variables were missing from dsenv. I got that resolved and now I receive an abnormal termination error in the web services transformer stage. I get no oth...