Paging :- QMF & Stored Proc guru (& guru-ettes)

Nick Cianci

Paging :- QMF & Stored Proc guru (& guru-ettes)
Hi,
I just got posed a curly question by a developer.

"How do you call a Stored Proc from QMF?"

My short answer was that you can't. As I don't believe that QMF is equipped
to pass the parameters or interpret the results ...

... but as per all things, just because you don't believe it can be done
doesn't mean that it can't. So if anybody out there has knowledge to the
contrary please let me know.

Cheers,
Nick Cianci
DB2 DBA - CCRI Project
2nd Floor (West) 484 StKilda Rd MELBOURNE 3004
* (+613) 9865-8554 ** New extension **
(+61) 0408-64 06 01
* [login to unmask email]
_______________________________________________________________

No trees were killed in the sending of this
message. However - a large number of
electrons were terribly inconvenienced.
_______________________________________________________________



Kurt Sahlberg

Re: Paging :- QMF & Stored Proc guru (& guru-ettes)
(in response to Nick Cianci)
Hi Nick,
You are right.
See doc II12610 I had the same question
and had IBM update the doc.
10. QMF V6 does not support Stored Procedures and Functions.
Regards,
Kurt

>>> [login to unmask email] 12/20/00 06:07PM >>>
Hi,
I just got posed a curly question by a developer.

"How do you call a Stored Proc from QMF?"

My short answer was that you can't. As I don't believe that QMF is equipped
to pass the parameters or interpret the results ...

... but as per all things, just because you don't believe it can be done
doesn't mean that it can't. So if anybody out there has knowledge to the
contrary please let me know.

Cheers,
Nick Cianci
DB2 DBA - CCRI Project
2nd Floor (West) 484 StKilda Rd MELBOURNE 3004
* (+613) 9865-8554 ** New extension **
(+61) 0408-64 06 01
* [login to unmask email]
_______________________________________________________________

No trees were killed in the sending of this
message. However - a large number of
electrons were terribly inconvenienced.
_______________________________________________________________






Matt Kelley

Re: Paging :- QMF & Stored Proc guru (& guru-ettes)
(in response to Kurt Sahlberg)
On Thu, 21 Dec 2000 11:07:26 +1100, Cianci, Nick
<[login to unmask email]> wrote:

>"How do you call a Stored Proc from QMF?"

You cannot do so from QMF running on the mainframe, but QMF for Windows
allows you to write a CALL statement in a query window, and invokes the
specified stored procedure, allowing for input and output parameters, as
well as multiple result sets.

-Matt



James Campbell

Re: Paging :- QMF & Stored Proc guru (& guru-ettes)
(in response to Matt Kelley)
On DB2 V6 yet? If so, you could write a table function that invokes the SP
and returns whatever from the SP via columns in the function.

The only caveat is that QMF V3.3.1 (which is what QMF V6 _really_ is)
produces its own error messages - so the tokens in any DB2 V6 errors will be
mapped in an "interesting" manner.

/* standard disclaimer */
James Campbell
DBA
Hansen Corporation, Doncaster
+61 3 9843 8442
[login to unmask email]
-----Original Message-----

On Thu, 21 Dec 2000 11:07:26 +1100, Cianci, Nick
<[login to unmask email]> wrote:

>"How do you call a Stored Proc from QMF?"



**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************



Rick Creech

Re: Paging :- QMF & Stored Proc guru (& guru-ettes)
(in response to James Campbell)
Hi,

I know you can write rexx in qmf as a qmf proc...so maybe you can call a
stored proc from one of the rexxes that you write.

hth,

Rick Creech


>From: "Cianci, Nick" <[login to unmask email]>
>Reply-To: DB2 Data Base Discussion List <[login to unmask email]>
>To: [login to unmask email]
>Subject: Paging :- QMF & Stored Proc guru (& guru-ettes)
>Date: Thu, 21 Dec 2000 11:07:26 +1100
>
>Hi,
> I just got posed a curly question by a developer.
>
>"How do you call a Stored Proc from QMF?"
>
>My short answer was that you can't. As I don't believe that QMF is equipped
>to pass the parameters or interpret the results ...
>
>... but as per all things, just because you don't believe it can be done
>doesn't mean that it can't. So if anybody out there has knowledge to the
>contrary please let me know.
>
>Cheers,
> Nick Cianci
> DB2 DBA - CCRI Project
> 2nd Floor (West) 484 StKilda Rd MELBOURNE 3004
> * (+613) 9865-8554 ** New extension **
> (+61) 0408-64 06 01
> * [login to unmask email]
>_______________________________________________________________
>
>No trees were killed in the sending of this
>message. However - a large number of
>electrons were terribly inconvenienced.
>_______________________________________________________________
>
>
>
>
>

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com



Phil Grainger

Re: Paging :- QMF & Stored Proc guru (& guru-ettes)
(in response to Rick Creech)
Maybe I am missing the point of the question, but CALL "stored procedure" is just an SQL statement like anything else

So, in a QMF query you can code CALL "storedprocedure" etc etc etc.

Maybe that isn't what the question means - if not, sorry

Phil Grainger
Computer Associates

-----Original Message-----
From: rick creech [mailto:[login to unmask email]
Sent: 21 December 2000 14:58
To: [login to unmask email]
Subject: Re: [DB2-L] Paging :- QMF & Stored Proc guru (& guru-ettes)


Hi,

I know you can write rexx in qmf as a qmf proc...so maybe you can call a
stored proc from one of the rexxes that you write.

hth,

Rick Creech


>From: "Cianci, Nick" <[login to unmask email]>
>Reply-To: DB2 Data Base Discussion List <[login to unmask email]>
>To: [login to unmask email]
>Subject: Paging :- QMF & Stored Proc guru (& guru-ettes)
>Date: Thu, 21 Dec 2000 11:07:26 +1100
>
>Hi,
> I just got posed a curly question by a developer.
>
>"How do you call a Stored Proc from QMF?"
>
>My short answer was that you can't. As I don't believe that QMF is equipped
>to pass the parameters or interpret the results ...
>
>... but as per all things, just because you don't believe it can be done
>doesn't mean that it can't. So if anybody out there has knowledge to the
>contrary please let me know.
>
>Cheers,
> Nick Cianci
> DB2 DBA - CCRI Project
> 2nd Floor (West) 484 StKilda Rd MELBOURNE 3004
> * (+613) 9865-8554 ** New extension **
> (+61) 0408-64 06 01
> * [login to unmask email]
>_______________________________________________________________
>
>No trees were killed in the sending of this
>message. However - a large number of
>electrons were terribly inconvenienced.
>_______________________________________________________________
>
>
>
>
>

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com






Dave Nance

Re: Paging :- QMF & Stored Proc guru (& guru-ettes)
(in response to Phil Grainger)
Not speaking from experience, but should be able to call from a QMF proc. Since your proc is a rexx routine, you can get anything done there that you can do in any other rexx procedure.

Dave Nance
First Health Services, Corp.
(804)527-6841

>>> [login to unmask email] 12/20/00 07:07PM >>>
Hi,
I just got posed a curly question by a developer.

"How do you call a Stored Proc from QMF?"

My short answer was that you can't. As I don't believe that QMF is equipped
to pass the parameters or interpret the results ...

... but as per all things, just because you don't believe it can be done
doesn't mean that it can't. So if anybody out there has knowledge to the
contrary please let me know.

Cheers,
Nick Cianci
DB2 DBA - CCRI Project
2nd Floor (West) 484 StKilda Rd MELBOURNE 3004
* (+613) 9865-8554 ** New extension **
(+61) 0408-64 06 01
* [login to unmask email]
_______________________________________________________________

No trees were killed in the sending of this
message. However - a large number of
electrons were terribly inconvenienced.
_______________________________________________________________






Phil Grainger

Re: Paging :- QMF & Stored Proc guru (& guru-ettes)
(in response to Dave Nance)
Of course,

It's just struck me - it's the return parameters that are the problem.

Obviously I am in Christmas go-slow mode already

Apologies, but the Rexx suggestions look like possibilities

Phil G

-----Original Message-----
From: David Nance [mailto:[login to unmask email]
Sent: 21 December 2000 16:40
To: [login to unmask email]
Subject: Re: [DB2-L] Paging :- QMF & Stored Proc guru (& guru-ettes)


Not speaking from experience, but should be able to call from a QMF proc. Since your proc is a rexx routine, you can get anything done there that you can do in any other rexx procedure.

Dave Nance
First Health Services, Corp.
(804)527-6841

>>> [login to unmask email] 12/20/00 07:07PM >>>
Hi,
I just got posed a curly question by a developer.

"How do you call a Stored Proc from QMF?"

My short answer was that you can't. As I don't believe that QMF is equipped
to pass the parameters or interpret the results ...

... but as per all things, just because you don't believe it can be done
doesn't mean that it can't. So if anybody out there has knowledge to the
contrary please let me know.

Cheers,
Nick Cianci
DB2 DBA - CCRI Project
2nd Floor (West) 484 StKilda Rd MELBOURNE 3004
* (+613) 9865-8554 ** New extension **
(+61) 0408-64 06 01
* [login to unmask email]
_______________________________________________________________

No trees were killed in the sending of this
message. However - a large number of
electrons were terribly inconvenienced.
_______________________________________________________________




=======================



Alessandro Brezzi

Re: Paging :- QMF & Stored Proc guru (& guru-ettes)
(in response to Phil Grainger)
Hi all,
I'm just curious about this statement "...Since your proc is a rexx
routine, you can get anything done there that you can do in any other rexx
procedure."
This sound the same as what is stated in the "Developping QMF Appl" manual...
I try to use some ISPF services inside a procedure with logic: VGET, VPUT
and DISPLAY. Only the DISPLAY service work, as I can get back a RC of 8 in
VGET and even in VPUT ("This variable not exist", in a PUT ?!?!).
Somebody here have written a PWL in QMF using ISPF services?

T.I.A. Alessandro


At 11:40 AM 12/21/00 -0500, you wrote:
>Not speaking from experience, but should be able to call from a QMF proc.
>Since your proc is a rexx routine, you can get anything done there that
>you can do in any other rexx procedure.
>
>Dave Nance
>First Health Services, Corp.
>(804)527-6841
>
> >>> [login to unmask email] 12/20/00 07:07PM >>>
>Hi,
> I just got posed a curly question by a developer.
>
>"How do you call a Stored Proc from QMF?"
>
>My short answer was that you can't. As I don't believe that QMF is equipped
>to pass the parameters or interpret the results ...
>
>... but as per all things, just because you don't believe it can be done
>doesn't mean that it can't. So if anybody out there has knowledge to the
>contrary please let me know.
>
>Cheers,
> Nick Cianci
> DB2 DBA - CCRI Project
> 2nd Floor (West) 484 StKilda Rd MELBOURNE 3004
> * (+613) 9865-8554 ** New extension **
> (+61) 0408-64 06 01
> * [login to unmask email]
>_______________________________________________________________
>
>No trees were killed in the sending of this
>message. However - a large number of
>electrons were terribly inconvenienced.
>_______________________________________________________________



James Campbell

Re: Paging :- QMF & Stored Proc guru (& guru-ettes)
(in response to Alessandro Brezzi)
No, QMF cannot handle an SQL CALL. Even with no parameters. Even QMF 3.3.1
(aka V6)

I suspect Nick might even have problems calling a non-QMF rexx program that
invokes the rexx-db2 interface. QMF uses CAF and rexx-db2 uses RRSAF (at
least it does in DB2 V6) - and they cannot be mixed in an address space.

/* standard disclaimer */
James Campbell
DBA
Hansen Corporation, Doncaster
+61 3 9843 8442
[login to unmask email]
-----Original Message-----
From: Grainger, Phil [mailto:[login to unmask email]
Sent: Friday, December 22, 2000 4:13 AM
To: [login to unmask email]
Subject: Re: [DB2-L] Paging :- QMF & Stored Proc guru (& guru-ettes)


Of course,

It's just struck me - it's the return parameters that are the problem.

Obviously I am in Christmas go-slow mode already

Apologies, but the Rexx suggestions look like possibilities

Phil G

-----Original Message-----
From: David Nance [mailto:[login to unmask email]
Sent: 21 December 2000 16:40
To: [login to unmask email]
Subject: Re: [DB2-L] Paging :- QMF & Stored Proc guru (& guru-ettes)


Not speaking from experience, but should be able to call from a QMF proc.
Since your proc is a rexx routine, you can get anything done there that you
can do in any other rexx procedure.

Dave Nance
First Health Services, Corp.
(804)527-6841

>>> [login to unmask email] 12/20/00 07:07PM >>>
Hi,
I just got posed a curly question by a developer.

"How do you call a Stored Proc from QMF?"

My short answer was that you can't. As I don't believe that QMF is equipped
to pass the parameters or interpret the results ...

... but as per all things, just because you don't believe it can be done
doesn't mean that it can't. So if anybody out there has knowledge to the
contrary please let me know.

Cheers,
Nick Cianci
DB2 DBA - CCRI Project
2nd Floor (West) 484 StKilda Rd MELBOURNE 3004
* (+613) 9865-8554 ** New extension **
(+61) 0408-64 06 01
* [login to unmask email]
_______________________________________________________________

No trees were killed in the sending of this
message. However - a large number of
electrons were terribly inconvenienced.
_______________________________________________________________








http://www.ryci.com/db2-l. The owners of the list can be reached at
[login to unmask email]







**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************



Alan Smith

Re: Paging :- QMF & Stored Proc guru (& guru-ettes)
(in response to James Campbell)
Don't know QMF or rexx/db2, but...
I believe in any case that you can't call a stored procedure from a
dynamically-prepared sql statement - unless it's an ODBC program. You can't
call one from DSNTEP2, for instance. You could use UDFs though if you're V6.

Alan Smith




> ------------------------------
>
> Date: Thu, 21 Dec 2000 08:57:43 -0600
> From: rick creech <[login to unmask email]>
> Subject: Re: Paging :- QMF & Stored Proc guru (& guru-ettes)
>
> Hi,
>
> I know you can write rexx in qmf as a qmf proc...so maybe you can call a
> stored proc from one of the rexxes that you write.
>
> hth,
>
> Rick Creech
>
>
>> From: "Cianci, Nick" <[login to unmask email]>
>> Reply-To: DB2 Data Base Discussion List <[login to unmask email]>
>> To: [login to unmask email]
>> Subject: Paging :- QMF & Stored Proc guru (& guru-ettes)
>> Date: Thu, 21 Dec 2000 11:07:26 +1100
>>
>> Hi,
>> I just got posed a curly question by a developer.
>>
>> "How do you call a Stored Proc from QMF?"
>>
>> My short answer was that you can't. As I don't believe that QMF is equipped
>> to pass the parameters or interpret the results ...
>>
>> ... but as per all things, just because you don't believe it can be done
>> doesn't mean that it can't. So if anybody out there has knowledge to the
>> contrary please let me know.
>>
>> Cheers,
>> Nick Cianci
>> DB2 DBA - CCRI Project
>> 2nd Floor (West) 484 StKilda Rd MELBOURNE 3004
>> * (+613) 9865-8554 ** New extension **
>> (+61) 0408-64 06 01
>> * [login to unmask email]
>> _______________________________________________________________
>>
>> No trees were killed in the sending of this
>> message. However - a large number of
>> electrons were terribly inconvenienced.
>> _______________________________________________________________