z/OS DB2 SPUFI called procedure

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

N61601@gmail.com - 31 Mar 2008 16:21 GMT

Can you use SPUFI to call a procedure in z/OS DB2?

Regards,
Serenity

Reply to this Message

Knut Stolze - 31 Mar 2008 17:57 GMT

> Can you use SPUFI to call a procedure in z/OS DB2?

No.

Signature

Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

Reply to this Message

N61601@gmail.com - 31 Mar 2008 18:58 GMT

> N61...@gmail.com wrote:
> > Can you use SPUFI to call a procedure in z/OS DB2?
>
> No.

What can we use on z/OS for quick & dirty storproc testing?

Serenity

Reply to this Message

Knut Stolze - 01 Apr 2008 18:03 GMT

>> N61...@gmail.com wrote:
>> > Can you use SPUFI to call a procedure in z/OS DB2?
>>
>> No.
>
> What can we use on z/OS for quick & dirty storproc testing?

I usually use a quick and dirty Java application from my Laptop.
Alternatively, you can use the DB2 LUW command line - or a simple C
program.

Signature

Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

Reply to this Message

N61601@gmail.com - 04 Apr 2008 14:49 GMT

> Alternatively, you can use the DB2 LUW command line - or a simple C
> program.

Should the following set of commands work for a stored procedure that
requires and returns no value?

DB2 CONNECT TO BIGBOX USER racfid USING racfpassword
DB2 SET CURRENT SQLID = 'MYDB'
DB2 SET CURRENT SCHEMA = 'MYDB'
DB2 CALL MYDB.TEST1()

Thank you,
Serenity

Reply to this Message

Knut Stolze - 07 Apr 2008 12:16 GMT

>> Alternatively, you can use the DB2 LUW command line - or a simple C
>> program.
[quoted text clipped - 6 lines]
> DB2 SET CURRENT SCHEMA = 'MYDB'
> DB2 CALL MYDB.TEST1()

Yes, although you don't need the two SET statements, and I would put
double-quotes around each statement to avoid nasty surprises by the shell
interfering.

Signature

Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

Reply to this Message