Re: [Squirrel-sql-users] execute DB2 stored procedure from Squirrel

[Robert M. <rob...@gm...>]

On 2/20/07, David Schmitt <dav...@ho...> wrote:
> Can you execute a zOS (mainframe) DB2 stored procedure from Squirrel? This
> is handy for testing the stored proc. I haven't been able to make it work.
> For example:
>
> call SCHDB1.J5143106(10,1,@x1,@x2); does not work.
>
> I don't think you can do this interactively with DB2 like you can with
> MySQL. I may not have the latest DB2 JDBC driver but I'm not sure this is
> the problem. If there's no way to do it is there a plugin available? I
> looked and couldn't find one. If there is no plugin available can any plugin
> experts tell me if it's feasible to write one. I've briefly looked over the
> example and MySQL plugin code and would be willing to take a crack at it.
>

Hi Dave,

There is a DB2 plugin available in the latest snapshot release (It's
new and will be available in 2.5).  What is the error message you get
when you execute that call as a statement?

Rob