MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » September 2011

Re: WRKQRY WAS:RE: Storing Numeric Values in the Database



fixed

Bryce,

In a simplified manner of speaking, RUNQRY is how you run a QRY defined with
WRKQRY. You can use it, for example, from within a CL program. For example:
RUNQRY QRY(mylib/myqry) . The QRY parameter is optional, allowing you to run
a quick query with runqry qryfile(mylib/myfile) (or runqry () mylib/myfile).

Please be aware that QRY uses the "old" DB engine (CQE), and that means that
some queries can be slower than their SQL counterparts. If you have the
product installed, you could work with Query Manager (QM). It is a little
more complex, but more flexible in its reporting capabilities. Check out
STRQM.

Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--



On Fri, Sep 2, 2011 at 4:33 PM, Bryce Martin <BMartin@xxxxxxxxxxxx> wrote:

ah, cool Thanks Rob. Any reason why people don't mention using it? Whey
they always mention runqry or the others? Is wrkqry inferior? Is there
something I don't know that I don't know? With as much SQL as I do and
wrkqry meeting my needs pretty well I've never really had the need or
curiosity to explore the others...any insight is great :)


Thanks
Bryce Martin
Programmer/Analyst I
570-546-4777



rob@xxxxxxxxx
Sent by: midrange-l-bounces@xxxxxxxxxxxx
09/02/2011 04:06 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
cc

Subject
RE: Storing Numeric Values in the Database






WRKQRY is part of 5###QU1 - Query for i5/OS


Rob Berendt
--
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Bryce Martin <BMartin@xxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 09/02/2011 04:04 PM
Subject: RE: Storing Numeric Values in the Database
Sent by: midrange-l-bounces@xxxxxxxxxxxx



I pretty much exclusively use zoned. The only time I mess with packed is
when working with a piece of legacy BPCS code (and even then I use mostly
zoned). I use SQL via STRSQL, FROG, or iNav (depends on what I'm doing).
I use WRKQRY a lot (is this a taatool?, not sure... it was here when I
started and works GREAT for lots of stuff... I think it is because I see
lots of other qry references that don't mention it). Anyway... zoned is
easy to read and easy to use and I have yet to have a problem with
performance. Storage is cheap, so storing packed instead of zoned to save


a few bytes seems silly (unless you are storing petabytes of information
maybe).

Now, I'm self taught (on the job) and zoned always felt more natural
(coming from c++ in college) than trying to work with packed. I don't
work with multiple CCSID's so that concern has never come up. Easy to
read, easy to use...


Thanks
Bryce Martin
Programmer/Analyst I
570-546-4777
--- This message (including any attachments) is intended only for the use
of the individual or entity to which it is addressed and may contain
information that is non-public, proprietary, privileged, confidential, and

exempt from disclosure under applicable law. If you are not the intended
recipient, you are hereby notified that any use, dissemination,
distribution, or copying of this communication is strictly prohibited. If
you have received this communication in error, please notify us and
destroy this message immediately. ---
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



--- This message (including any attachments) is intended only for the use
of the individual or entity to which it is addressed and may contain
information that is non-public, proprietary, privileged, confidential, and
exempt from disclosure under applicable law. If you are not the intended
recipient, you are hereby notified that any use, dissemination,
distribution, or copying of this communication is strictly prohibited. If
you have received this communication in error, please notify us and destroy
this message immediately. ---
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.







Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact