RE: Query Manager Prompting

On Fri, 14 December 2001, "Draper, Dale" wrote:

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


Keep in mind that the above relates to Query/400 -- not Query Manager. (Or did 
the 'Prompted' QM interface get this added to it recently?) The resulting 
*QRYDFN object might however be later converted into a *QMQRY object.

For Query Manager queries, you use SQL for 'Query creation mode' and enter the 
variables directly into the SQL statement through the Edit Query display. (Note 
that once a variable is part of the SQL statement, SQL prompting can no longer 
be done. This is because the variable can become any part of or even all of the 
SQL statement; the prompter has no way to know what you intend to put in there.)

The variable is simply a name preceded by an ampersand, e.g., &VAR1 or 
&MYVARIABLE. There are a few basic rules to variables, but one step at a time.

Commonly, a CL or RPG program will present some formatted display to allow 
nice, neat entry of the values to substitute for the variables. These values 
are then passed into the query through the STRQMQRY SETVAR() parameter.

Tom Liotta

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

--
Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone  253-872-7788
Fax  253-872-7904
http://www.400Security.com


___________________________________________________
The ALL NEW CS2000 from CompuServe
 Better!  Faster! More Powerful!
 250 FREE hours! Sign-on Now!
 http://www.compuserve.com/trycsrv/cs2000/webmail/