Re: OPNQRYF problem

[Pat Barber <mboceanside@xxxxxxxxxxxxxxxx>]

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"')