|
As for *QMFORMs, as Tom said, writing the source is not for the faint of heart. If you really need to do it, get the Query Management Programming book - it'll be on the same page as the SQL manuals at InfoCenter. See the book at
<http://publib.boulder.ibm.com/iseries/v5r1/ic2924/info/qmp/rbaromst.pdf? From that manual:
Query Management itself is not an end-user tool. The people who can use it most effectively are data processing professionals. They have the ability to create queries that can be used within both CL and high-level language programs, and other SAA systems.
And to get an idea of what you'll be dealing with, execute the RTVQMFORM command against a Query/400 *QRYDFN object.
The book for STRQM is iSeries Query Manager at <http://publib.boulder.ibm.com/iseries/v5r1/ic2924/info/qmu/rbao1mst.pdf> Source file for QMQRY is QQMQRYSRC, record length 91 Source file for QMFORM is QQMFORMSRC. record length 162Yes, those lengths are right - and are best honored exactly. This has to do with the fact that QM (Query Management) is a cross-platform technology in IBM's world. You can import a QMQRY from a mainframe that will run on a 400, AFAIK. The general term for this is Systems Application Architecture (SAA) Query commands.
The ability to use QM objects is part of the operating system, so the STRQMPRC and STRQMQRY commands are always there, as well as the RTVQM*, CRTQM*, and WRKQM* sets of commands.
You also have the ability to run multiple QM functions using procedures. These are source members in a source file, usually named QQMPRCSRC. The above-cited manual tells how to use these. Record length for these is also 91. I've not yet worked out substitution values for procedures, Although it appears that you can set a value in the global variable space in an external program, and the QMQRY will pick it up automatically - no need to use a SETVAR - can't anyway.
At 09:51 AM 6/21/2005, you wrote:
midrange.com
What library is strqm in? When I enter strqm* I just get
Opt Command Library Text
STRQMPRC QSYS Start Query Management Proc
STRQMQRY QSYS Start Query Management Query
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Campin
Sent: Monday, June 20, 2005 4:52 PM
To: midrange-l@xxxxxxxxxxxx
Subject: QMQRY/QMFORM
>> Is there an editor for files of type QMFORM, either on the AS400 or
in
>> Ops Navigator, etc.?
STRQM. Option 1 edits the Queries. Option two edit the forms. Once you
build a query, you can go directly to the form with a function key.
Am I missing the question? QMFORMS are, also, stored as text and can be
edited by hand but that is not for the faint of heart.
--
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
