Eric, after putting in the :variable value, did you receive a second screen
names " Specify Dependent Value Qualifiers "?

Qualifier type . . . .   1

Query or file  . . . .
  Library  . . . . . .     QGPL


Using qualifier 1, put in any value for the second two as per my example.
I suspect this is missing?

The user interface is about the same as you are seeing with your SQL when
all is said and done though.



-----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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 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.