|
OK, I did it ugly;
SELECT RRN(a) RRN, a.IQDBSQ, a.IQDREC, a.IQDDTA
FROM G3X1DTA/INBDTA a
WHERE RRN(a) in (SELECT RRN(b)
FROM G3X1DTA/INBDTA b
WHERE b.IQDBSQ > 56000
and (b.IQDDTA like '%QTY¬32¬-%'
or b.IQDDTA like '%QTY*32*-%'))
or RRN(a) in (SELECT RRN(c) - 1
FROM G3X1DTA/INBDTA c
WHERE c.IQDBSQ > 56000
and (c.IQDDTA like '%QTY¬32¬-%'
or c.IQDDTA like '%QTY*32*-%'))
or RRN(a) in (SELECT RRN(d) - 2
FROM G3X1DTA/INBDTA d
WHERE d.IQDBSQ > 56000
and (d.IQDDTA like '%QTY¬32¬-%'
or d.IQDDTA like '%QTY*32*-%'))
'%QTY%%%%-%' wasn't giving me the desired data either.
Guy
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.