Re: SQL: How to create a list of MISSING numbers in a sequence

Joel,

Is LDATE a timestamp? If so, you could create a view just like this:

create view mylib/diff_log as
with t1 as(
select max(ldate) as max_ldate from rjsimage/doclog00
)
select timestampdiff(2,
cast( current_timestamp - max_ldate as char(22)) )
as diff
from t1
;

This would give you the number of seconds after the last LDATE recorded.
Then you could wither check it in your poll program and/or incorporate it
in a BEFORE INSERT trigger...


It would be nice to have an index on LDATE for performance.


HTH,
Luis

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries