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: email@example.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/
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.