Neoview SQL Reference Manual (R2.2)

SELECT LASTNOTNULL (I1) AS LASTNOTNULL
FROM mining.seqfcn SEQUENCE BY TS;
LASTNOTNULL
-----------
6215
6215
19058
19058
11966
--- 5 row(s) selected.
348 SQL Functions and Expressions