DELRECS SA7rPDCJUSERID  0
BEGIN DECLARE SECTION
END DECLARE SECTION
WHENEVER SQLERROR GOTO ERROR
WHENEVER NOT FOUND GOTO ERROR
SELECT MAX(SECONDS_TIMESTAMP)                INTO :interval_seconds                FROM LANM.RING_PERFORMANCE               WHERE SEGMENT_NUMBER = :segment                 AND DATE_LOGGED  <= :EndDate
DELETE FROM LANM.RING_PERFORMANCE               WHERE SEGMENT_NUMBER = :segment                 AND SECONDS_TIMESTAMP <= :interval_seconds
COMMIT
EndDate
Log_Time
Log_Date
interval_seconds
utilization
segment
Start
Finish