|
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 PALL Aeropower Corp. / SR Programmer Analyst Website: www.pall.com / Email: Peter_Vidal@Pall.com Phone: 727-539-8448, x2414
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 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.