|
Peter First, you need to put variables in place of the constants - 102 becomes :SHIP_YEAR (remember the colon) - I assume you've done that. Then your CL variables need to be *CHAR At 02:14 PM 8/20/02 -0400, you wrote: >Hi list! > >I know how to send parms to the query from the STRQMQRY command, but I have a >problem with RANGE (I guess). My query record selection is like this: > > DYAA4C EQ 102 >AND DYAA4D RANGE 10 12 >AND DYAA39 GE 1020731 > >Is this correct? >STRQMQRY QMQRY(PABQ02) OUTPUT(*OUTFILE) + >OUTFILE(QTEMP/PABQ02) ALWQRYDFN(*ONLY) + >SETVAR((SHIP_YEAR &SHIP_YEAR) + > (SFMONTH &SFMONTH) + > (STMONTH &STMONTH) + > (PRM_DATE &PRM_DATE)) > >This is not working. If I put the parameters directly on the query, it pulls >the data correctly. >What is wrong? > >Thanks in advance. > >PETER VIDAL
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 copyright@midrange.com.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.