QMF Question

SUBSCRIBE DB2-L Anil Kale

QMF Question
Hi All !

Question Regarding QMF V9 on z/OS:

Why would I not see objects using the LIST command (specifying correct
TYPE, OWNER, and NAME), but I can view them using the DISplay command.

For example:
LIST PROCS (OWNER=XYZ NAME=MY_PROC_01
No objects were found to satisfy your LIST command.

However,
DIS PROC XYZ.MY_PROC_01

would display the PROC

Btw, the proc was saved using SHARE=Y
SAVE PROC AS XYZ.MY_PROC_01 (SHARE=YES

I would appreciate if someone can help me understand the issue here.

Thanks.

Anil

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *

_____________________________________________________________________

IDUG North America Attendee Testimonial-
"The most important thing I always find at IDUG is the revisiting of old assumptions, with new functions and features."
_____________________________________________________________________

Bala

QMF Question
(in response to SUBSCRIBE DB2-L Anil Kale)
Hello List,

QMF v8, DB2 v8 - z/Os 1.7 is the environment.

Is there a say in QMF to check if the returned rows is zero ? I want to
distinguish the situation where the Query returns empty table. We have got
few QMf PROCs written for generating reports and sometimes, they send out
empty reports/emails.

I am writing this after spending days looking at QMF bookshelf. I also
appreciate any suggestions.

Thanks !

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/solutions-journal.html - home of the IDUG Solutions Journal
Technical atricles from world famous authors in DB2's most prestigious, peer reviewed
magazine now on-line!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Mike Vaughan

Re: QMF Question
(in response to Bala)
Take a look at the global variable DSQAO_NUM_FETCHED - it should give you what you are looking for.

________________________________
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of DB2DBAzOS
Sent: Thursday, December 10, 2009 4:08 AM
To: [login to unmask email]
Subject: [DB2-L] QMF Question

Hello List,

QMF v8, DB2 v8 - z/Os 1.7 is the environment.

Is there a say in QMF to check if the returned rows is zero ? I want to distinguish the situation where the Query returns empty table. We have got few QMf PROCs written for generating reports and sometimes, they send out empty reports/emails.

I am writing this after spending days looking at QMF bookshelf. I also appreciate any suggestions.

Thanks !

________________________________

[ http://www.idug.org/images/M_images/idug%20na3.jpg ] < http://www.idug.org/db2-north-america-conference/index.html >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >


-----Message Disclaimer-----

This e-mail message is intended only for the use of the individual or
entity to which it is addressed, and may contain information that is
privileged, confidential and exempt from disclosure under applicable law.
If you are not the intended recipient, any dissemination, distribution or
copying of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately by
reply email to [login to unmask email] and delete or destroy all copies of
the original message and attachments thereto. Email sent to or from the
Principal Financial Group or any of its member companies may be retained
as required by law or regulation.

Nothing in this message is intended to constitute an Electronic signature
for purposes of the Uniform Electronic Transactions Act (UETA) or the
Electronic Signatures in Global and National Commerce Act ("E-Sign")
unless a specific statement to the contrary is included in this message.

While this communication may be used to promote or market a transaction
or an idea that is discussed in the publication, it is intended to provide
general information about the subject matter covered and is provided with
the understanding that The Principal is not rendering legal, accounting,
or tax advice. It is not a marketed opinion and may not be used to avoid
penalties under the Internal Revenue Code. You should consult with
appropriate counsel or other advisors on all matters pertaining to legal,
tax, or accounting obligations and requirements.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/solutions-journal.html - home of the IDUG Solutions Journal
Technical atricles from world famous authors in DB2's most prestigious, peer reviewed
magazine now on-line!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Bala

Re: QMF Question
(in response to Mike Vaughan)
Thank you, Mike. I wrote a Rexx procedure to process using this global
variable.


On Fri, Dec 11, 2009 at 12:46 AM, Vaughan, Mike
<[login to unmask email]>wrote:

> Take a look at the global variable DSQAO_NUM_FETCHED - it should give you
> what you are looking for.
>
> ------------------------------
> *From:* IDUG DB2-L [mailto:[login to unmask email] *On Behalf Of *DB2DBAzOS
> *Sent:* Thursday, December 10, 2009 4:08 AM
> *To:* [login to unmask email]
> *Subject:* [DB2-L] QMF Question
>
> Hello List,
>
> QMF v8, DB2 v8 - z/Os 1.7 is the environment.
>
> Is there a say in QMF to check if the returned rows is zero ? I want to
> distinguish the situation where the Query returns empty table. We have got
> few QMf PROCs written for generating reports and sometimes, they send out
> empty reports/emails.
>
> I am writing this after spending days looking at QMF bookshelf. I also
> appreciate any suggestions.
>
> Thanks !
>
> ------------------------------
>
> [image: IDUG - The Worldwide DB2 User Community! ] < http://www.idug.org/db2-north-america-conference/index.html >
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are
> not already an IDUG member, please register here. < http://www.idug.org/register >
>
> -----Message Disclaimer-----
>
> This e-mail message is intended only for the use of the individual or
> entity to which it is addressed, and may contain information that is
> privileged, confidential and exempt from disclosure under applicable law.
> If you are not the intended recipient, any dissemination, distribution or
> copying of this communication is strictly prohibited. If you have
> received this communication in error, please notify us immediately by
> reply email to [login to unmask email] and delete or destroy all copies of
> the original message and attachments thereto. Email sent to or from the
> Principal Financial Group or any of its member companies may be retained
> as required by law or regulation.
>
> Nothing in this message is intended to constitute an Electronic signature
> for purposes of the Uniform Electronic Transactions Act (UETA) or the
> Electronic Signatures in Global and National Commerce Act ("E-Sign")
> unless a specific statement to the contrary is included in this message.
>
> While this communication may be used to promote or market a transaction
> or an idea that is discussed in the publication, it is intended to provide
> general information about the subject matter covered and is provided with
> the understanding that The Principal is not rendering legal, accounting,
> or tax advice. It is not a marketed opinion and may not be used to avoid
> penalties under the Internal Revenue Code. You should consult with
> appropriate counsel or other advisors on all matters pertaining to legal,
> tax, or accounting obligations and requirements.
>
>
> ------------------------------
>
> [image: IDUG - The Worldwide DB2 User Community! ] < http://www.idug.org/db2-north-america-conference/index.html >
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are
> not already an IDUG member, please register here. < http://www.idug.org/register >
>

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L