DATETIME dt, dt2
Long ll

CONNECT USING SQLCA_3;

SELECT COUNT(distinct eta_user.ANL_10S.HIST_TIMESTAMP)
INTO :LL
FROM eta_user.ANL_10S_KEY INNER JOIN eta_user.ANL_10S ON eta_user.ANL_10S_KEY.TABLE_INDEX = eta_user.ANL_10S.TABLE_INDEX
WHERE ((eta_user.ANL_10S_KEY.HIS_ACTIVE_KEY = 1) AND ((eta_user.ANL_10S.HIST_TIMESTAMP >=:dt) and (eta_user.ANL_10S.HIST_TIMESTAMP <=:dt2)));

DISCONNECT USING SQLCA_3;