create procedure HURCKES.SIGNONRH
(inout userin char(10),
inout sessin char(50),
inout ipin char(100),
inout urlin char(99))
LANGUAGE SQL
DETERMINISTIC
BEGIN

declare seq numeric(10,0);
select max(SEQID)+1 into seq from HURCKES.RICKLOG;
insert into HURCKES.RICKLOG values (seq, userin, sessin, ipin, urlin,current_date,current_time);
END