Answered: DB2 Catalog Netezza Database with More than 8 Character Name
Trying to do a CURSOR load into my DB2 (10.1 LUW) from a Netezza database. Unfortunately, the admin for the Netezza database gave it a 20 character name. Thusly, when I attempt to CATALOG the Netezza database, DB2 spits back an "SQL0104N An unexpected token was found following "DATABASE". I also get this error if I attempt to CATALOG with the AS parameter and a 8 character alias.
CATALOG DATABASE NETEZZA_DB_NAME_HERE AT NODE NETZNODE
CATALOG DATABASE NETEZZA_DB_NAME_HERE AS NETZAL AT NODE NETZNODE
I have no control over the naming or administration of the Netezza database.
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be
It took awhile to track down a version of Infosphere Federation Server to match our DB2 version, but we were able to do that and then able to create an ODBC wrapper, and then federate to the Netezza database.