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

[Luis Rodriguez <luisro58@xxxxxxxxx>]

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.