LSTCHG was numeric.....Sometimes it doesn't pay to get out of bed in the morning, although lately I've been learning (or in some cases re-learning) a lot of things. Thanks. --- jt <firstname.lastname@example.org> 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"') > > > (I never did see the problem, BTW, unless LSTCHG was > numeric.) > > jt > > > | -----Original Message----- > | From: email@example.com > | [mailto:firstname.lastname@example.org]On Behalf Of > email@example.com > | Sent: Monday, December 03, 2001 12:15 PM > | To: firstname.lastname@example.org > | Subject: RE: OPNQRYF problem > | > | > | > | <SNIP> > | ...since I never get > | OPNQRYF right the first few times anyway. > | <ENDSNIP> > | > | Who does? This is why I like SQL better. > | > | Rob Berendt > | > | ================== > | "They that can give up essential liberty to obtain > a little temporary > | safety deserve neither liberty nor safety." > | Benjamin Franklin > | > > <huge snip of prior messages> > > _______________________________________________ > This is the Midrange Systems Technical Discussion > (MIDRANGE-L) mailing list > To post a message email: MIDRANGE-L@midrange.com > To subscribe, unsubscribe, or change list options, > visit: > http://lists.midrange.com/cgi-bin/listinfo/midrange-l > or email: MIDRANGE-Lemail@example.com > Before posting, please take a moment to review the > archives > at http://archive.midrange.com/midrange-l. > ===== __________________________________________________ Do You Yahoo!? Buy the perfect holiday gifts at Yahoo! Shopping. http://shopping.yahoo.com
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.