RE: Query Manager Prompting

["Eric Kempter" <EKempter@xxxxxxxxxxxxxxx>]

I don't use an a.k.a. but thanks for the link.  It is very good!  I am
going to forward one particular response to Buck for the FAQ!

-----Original Message-----
From: Draper, Dale [mailto:dale.draper@seu.sega.com]
Sent: Friday, December 14, 2001 7:51 AM
To: 'midrange-l@midrange.com'
Subject: RE: Query Manager Prompting


And, strangely enough, a guy going by the name of Tony Myers (a.k.a.
Eric???) Just recently asked this on the comp.sys.ibm.as400.misc
newgroup (
to found here:
http://groups.google.com/groups?hl=en&lr=&safe=off&group=comp.sys.ibm.as
400.
misc )

Here is a direct link to the thread, looks to be some good answers
http://groups.google.com/groups?hl=en&th=327ab4c7a1a110c2


-----Original Message-----
From: Eric Kempter [mailto:EKempter@norcalwaste.com]
Sent: Thursday, December 13, 2001 4:18 PM
To: midrange-l@midrange.com
Subject: RE: Query Manager Prompting


When I attempt to add the variable within Query Manager to the select
statement (:variable), I receive an error - Host variable not permitted
here.  Does anybody know why this is?  I was able to resolve this issue
by converting the QMQRY to SQL and then adding variables (&variable) to
specific points in the WHERE statement.  Although the interface leaves
something to be desired (it looks like a program message display), it
beats presenting the user with a select records screen within a query
and it allows retrieval of the variables just before it submits to
batch.

-----Original Message-----
From: Draper, Dale [mailto:dale.draper@seu.sega.com]
Sent: Wednesday, December 12, 2001 12:02 PM
To: 'midrange-l@midrange.com'
Subject: RE: Query Manager Prompting


IIRC If you search the archives, about a year ago or maybe a bit longer
this
came up.

Anyway, I was able to find documentation that I could use, so you should
have no problem.

Here's the CL I use:
==========
 PGM

 STRQMQRY   QMQRY(SEXAXYZ/CREDITREL1) QMFORM(*QMQRY) +
              ALWQRYDFN(*YES)

 ENDPGM
================

In the Query definition itself select records looks like this (where
field
HODOCO is the selectable field):

Field             Test   Value
HODOCO            EQ     :HODOCO

---------
If you  hit return from here you see a second screen:

-------------------
Type choices, press Enter.

  Qualifier type . . . .   1

  Query or file  . . . .   DUMMY
    Library  . . . . . .     SEXAXYZ

  For choice 2=File:
    File member  . . . .
 -----
Other Query definitions:

Output type is "1" display

--------------------------

And, strangely enough "DUMMY" does not exist as an object on my system.

I hope this helps.

-----Original Message-----
From: Eric Kempter [mailto:EKempter@norcalwaste.com]
Sent: Wednesday, December 12, 2001 11:45 AM
To: midrange-l@midrange.com
Subject: Query Manager Prompting


> Does anyone know how to get a query manager query to prompt a user for
> input.  I want to use the input to determine record selection
> criteria.
>
> TIA
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
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@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
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@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
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@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.