UPDATE RFGTABLE.MODELS SET REGISTERED = CURRENT TIMESTAMP WHERE (SEQNO=1 AND MODELID=:Hmodelid)
ROLLBACK
SELECT MAX(SEQNO) INTO :HmaxSeqNo FROM RFGTABLE.MODELS WHERE MODELID = :Hmodelid
DECLARE READ_MOD_ENT CURSOR FOR SELECT MODELID, TYPE, MODRSPFILE, REGISTERED, SEQNO, CONTENT FROM RFGTABLE.MODELS WHERE MODELID = :Hmodelid ORDER BY SEQNO
OPEN READ_MOD_ENT
FETCH READ_MOD_ENT INTO :Hmodelid, :Htype, :Hfilename, :Hdate, :Hseqno, :Hbuffer