RE: SQL before & after

DOOP!

All the "prior" is doing is renaming the file inside the SQL.

SELECT RRN(a), a.IQDBSQ, a.IQDREC, a.IQDDTA
  FROM G3X1DTA/INBDTA a                    
 WHERE a.IQDBSQ > 56000                    
   and a.IQDDTA like '%QTY%%%%-%'          

Also works but I'm not getting the data I want.
 
Regards, 
 
Guy 

------------------------------

date: Mon, 6 Feb 2006 14:42:24 -0500
from: "Henza, Guy" <GHenza@xxxxxxxxx>
subject: RE: SQL before & after

Rob, Walden,

I'm sure that I'm sure that was the example I was playing with a year
ago (unless I'm getting senile in my middle age).  

I've got an inbound EDI file (80 char records).  I want to select the
records that contain credits with a negative quantity and get the 3
records prior to that record.  The select statement below works but any
thing I put after the prior makes it fail.

SELECT IQDBSQ, IQDREC, IQDDTA 
  FROM G3X1DTA/INBDTA prior
 WHERE IQDBSQ > 56000 
   and IQDDTA like '%QTY%%%%-%' 
 
Any suggestions?  TIA
 
Guy