home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
IBM Presents OS/2 Software Hits 1995
/
OS-2_SW_HITS_2ND_EDITION_1995.ISO
/
i17
/
ur423843.dsk
/
CSD3.DFI
/
DELRECS.BND
(
.txt
)
< prev
next >
Wrap
DB2 Bind
|
1993-02-03
|
881b
|
17 lines
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