|
A slightly different tack on that is to just use the %SST and move the variable to replace the XXXXXX..... You can then just forget all that *cat *bcat etc,etc..... This method will work with numeric or alpha fields.... Somthing like this: chgvar var(%sst(&qryslt 13 6)) value(&VAR) chgvar var(%sst(&qryslt 38 6)) value(&var2) etc,etc jt wrote: > > Rob, > > I won't say I get OPNQRYF right the first time, every time (why I also use > &QRYSLT). But I have pretty good luck by typing complex selects in without > any variables, first. For example: > > CHGVAR &QRYSLT ('LSTCHG *GE "XXXXXX" *AND LSTCHG *LE "XXXXXX" *AND RECTYP = > "M"') > > Then I strip out the variables, and separate the strings: > > CHGVAR &QRYSLT ('LSTCHG *GE "' *cat XXXXXX *cat '" *AND LSTCHG *LE "' *cat > XXXXXX *cat '" *AND RECTYP = "M"') > > Which then leads to: > > CHGVAR &QRYSLT ('LSTCHG *GE "' *CAT + > &BEGUPD *CAT '" *AND LSTCHG *LE "' + > *CAT &ENDUPD *CAT '" *AND RECTYP + > = "M"')
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.