SQL 0440N SQLPROCEDURECOLS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roger - 25 Jul 2006 22:41 GMT

I have created a SQL stored procedure on DB2 V7 on Z/os. I have defined
it and compiled it wit no errors . When I try to run it from a Db2 V8
Fp12 client, its giving :

SQL0440N No authorized routine named "SQLPROCEDURECOLS" of type ""
having comp
atible arguments was found. SQLSTATE=42884

I have looked into SYSROUTINES tables on the mainframe and I don't see
any such routines.

However , if I run the stored procedure from a V7 client, I can execute
it successfully.

How can I make it run with V8 client ? Any input is greatly
apprecaited.

Thanks

Reply to this Message

Serge Rielau - 26 Jul 2006 02:25 GMT

> I have created a SQL stored procedure on DB2 V7 on Z/os. I have defined
> it and compiled it wit no errors . When I try to run it from a Db2 V8
[quoted text clipped - 12 lines]
> How can I make it run with V8 client ? Any input is greatly
> appreciated.

What's your client (ODBC, CLI, JDBC Type, which version)? I suspect the
client is calling this DB2 for LUW procedure under the covers, perhaps
to describe the signature of your procedure.
Could it be your client version is out of date? (just a wild guess)

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ondemandbusiness/conf2006/

Reply to this Message

Roger - 26 Jul 2006 13:15 GMT

I am running to Db2 Connect V8.1 with FP 12 and on the mainframe side
is Db2 V7
the SQL SP is running on a non WLM environment.
Thanks

> > I have created a SQL stored procedure on DB2 V7 on Z/os. I have defined
> > it and compiled it wit no errors . When I try to run it from a Db2 V8
[quoted text clipped - 27 lines]
> IOD Conference
> http://www.ibm.com/software/data/ondemandbusiness/conf2006/

Reply to this Message

Serge Rielau - 26 Jul 2006 13:31 GMT

> I am running to Db2 Connect V8.1 with FP 12 and on the mainframe side
> is Db2 V7
[quoted text clipped - 32 lines]
>> IOD Conference
>> http://www.ibm.com/software/data/ondemandbusiness/conf2006/

Oh! I thought you were running the same proc against zOS as against LUW.
I think a PMR would be in order.

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ondemandbusiness/conf2006/

Reply to this Message

Joachim Klassen - 26 Jul 2006 15:31 GMT

Roger schrieb:

> I have created a SQL stored procedure on DB2 V7 on Z/os. I have defined
> it and compiled it wit no errors . When I try to run it from a Db2 V8
[quoted text clipped - 14 lines]
>
> Thanks

IIRC you need a aditional PTF on DB2 z/OS which installs a couple of
stored procedures for ODBC metadata calls (eg. SQLTABLES ,
SQLPROCEDURECOLS):
PQ62695: ADD STORED PROCEDURES AND VIEWS FOR USE BY ODBC AND JDBC
DRIVERS

HTH
Joachim

Reply to this Message