SqlDbx Forum

SqlDbx

You are not logged in.

#1 2010-08-25 09:25:14

Mark Wang
Guest

Error Executing Stored Procedures

From System Objects -> Procedures, I am able to find list of all stored procedures, but only able to run stored procedures that required no input parameter. When executing a stored procedure that required input parameter, the pop-up window does display correct input parameters (with name and type). However, error is always return: "SQL0440N  No function by the name "SYSPROC.#######" having compatible arguments was found in the function path. SQLSTATE=42884"

#2 2010-08-25 20:27:54

sqldbxhelp
Administrator

Re: Error Executing Stored Procedures

What is your DB2 version?
Instead of choosing "Execute ..." click "Script Execute".
Is there's anything wrong with generated statement?

Offline

#3 2010-08-26 19:20:21

Mark Wang
Guest

Re: Error Executing Stored Procedures

z/OS version 8.
Get the same error when using the the generated script to execute.

#4 2010-08-26 21:36:56

sqldbxhelp
Administrator

Re: Error Executing Stored Procedures

We will need to take a closer look at it.
Can you email generated script and
stored procedure source if possible to support@sqldbx.com

Offline

Board footer

Powered by FluxBB