You should not be doing the compare with the setvar. It should only be passing 
a var. test that var in the qry. In the qry use the select record section to 
test the var   field ge :lodate

Kirk Goins
IBM Certified iSeries Technical Solutions Expert
Pacific Information Systems - An IBM Premier Business Partner

-----Original Message-----
From: Dan Rasch []
Sent: Thursday, May 09, 2002 12:44 PM
Subject: Passing parms to query

I followed up on the thread earlier of passing parms to a query,
and the results were good.

The query command I assembled was this (almost an exact copy from the
FAQ site):

SETVAR((LODATE 1011001))

beautiful, but I tried it with SETVAR((LODATE *GE 1010101))
and I get the error:

Too many values in list for parameter SETVAR.

I looked STRQMQRY up in the manuals (remember them) from V3R2
and it used the example of VAR1 and VAR2 being SQL statements,
but gave no indication of where these two variables belonged in
the QUERY definition.

The harder I think, the confuser I get.

Dan Rasch - because if the human species concentrated on the really
important things in life, there would be a shortage of fishing poles!
IBM Certified twice....... but still a couple PTFs away from Nirvana.

This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email:
To subscribe, unsubscribe, or change list options,
or email:
Before posting, please take a moment to review the archives

This thread ...


Return to Archive home page | Return to MIDRANGE.COM home page