DSXchange

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; sqlcode = -552; sqlstate = 42502

and

Surrogate_Key_Generator_33,1: Program not bound to database
Attempting to bind /opt/app/IBM/InformationServer/Server/DSComponents/bin/db2esql80.bnd to the database ETLDB ....failed

I'm trying to use the same connection parameters used for DB2 UDB stages (DB2 EE stages are not an option for us). Do you need a DB2 EE connection for the Surrogate Key Generator Stage, or am I just missing something with the properties?

Seems Either Key column name( ie is the one you are generating using the Surrogate Key Generator) is not there in the Target table.

Seems Either Key column name( ie is the one you are generating using the Surrogate Key Generator) is not there in the Target table.

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 Generator Stage without DB2 Enterprise connectivity.