|
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): STRQMQRY QMQRY(TDER3/PASSPARM) QMFORM(*QMQRY) ALWQRYDFN(*YES) 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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.