DSXchange

We just tracked down some fatal errors to the QualityStage Standardize Stage when using multiple instances of a shared container. We have a container that validates an address, rejects invalid rows, replaces nulls with default values, etc... In a parallel job, we have 2 entities coming in on a row, ...

It turns out this error was truly what it said, database permissions. ETLUSER was in a group which did not have 'Indirect Implicit Schema' authority. The error does seem misleading though as the Surrogate Key Generator does not need to 'CREATE SCHEMA.' Anyways, you can use the Surrogate Key Generato...

When using the Surrogate Key Generator Stage, the following errors are being generated: Surrogate_Key_Generator_33,1: Error Idx = 1; DB2Driver Embedded SQL message: SQL0552N "ETLUSER" does not have the privilege to perform operation "IMPLICIT CREATE SCHEMA". SQLSTATE=42502; sqlco...

In that case, where should the classpath for the new compiled java code go? Is there a specific folder to put that into?

Got it working but the problem was quite odd. At one point I had tr4j.jar as my classpath within the Java Transformer, but I had since changed it and it was not referenced anywhere I could see. However, when I deleted the Transformer Stage and added a new one... no more error :D I guess there was me...

I'm having an issue getting the Java Transformer Stage to work. At this point, I'm just using the sample UpperCase class and am able to run it successfully in a server job. When running a parallel job with a Java Transformer, the following error is returned and the job is aborted: Java_Transformer_1...

This is not allowed. For Enterprise stages (not referring to ODBC stages), you MUST keep the operating systems the same. Sorry. You will need to use ODBC (or the equivalent technology) to work in this type of environment. Thanks, that helps. Does the ODBC Enterprise Stage support "sparse"...

Hi, I'm needing to perform a "sparse" lookup, and I've read that the DB2 Enterprise Edition is required (currently only DB2 UDB API is configured). The concern I've got is DataStage 8 is installed on Linux and DB2 8 is installed on a separate AIX machine. Is there a way to get the DB2 Ente...