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 thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 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.