Kbase 19918: DB2CLI.PROCEDURES is an Undefined Name - ODBC Dsrv
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/17/2008 |
|
Status: Verified
FACT(s) (Environment):
ODBC DataServer
Progress 9.x
SYMPTOM(s):
Error when accessing a DB2 Universal Database via ODBC Dataserver.
S002:[MERANT][ODBC DB2 driver][DB2]SQL0204N "DB2CLI.PROCEDURES" is an
undefined name. SQLSTATE=42704.
CAUSE:
For versions of DB2 before DB2 Universal Database, the DB2CLI.PROCEDURES is used to retrieve information about stored procedures and their attributes.
DB2 Universal Database uses the SYSCAT.PROCEDURES and SYSCAT.PROCPARAMS catalog tables which contain information about stored procedures. The DB2CLI.PROCEDURES table is no longer required however the the MERANT ODBC driver still uses the
DB2CLI.PROCEDURES table.
FIX:
Create the db2cli.procedures table. (see IBM documentation for the procedure)