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 Enterprise Connector working with this setup?
I've heard there is a way to make DataStage see the database as "local." Has anyone had success with this, and if so would it work in this situation?
Any suggestions/experiences would be appreciated.
Thanks, Stephen
DB2 EE Config when DS on Linux, DB2 on AIX
Moderators: chulett, rschirm, roy
Thanks, that helps.Teej wrote: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.
Does the ODBC Enterprise Stage support "sparse" lookups?
- Stephen -