….
-- Теперь проверим, не знаем ли мы уже этого пользователя
SELECT count(*) INTO flag 
FROM sysdbopenuser 
WHERE who = USER 
AND db_name = my_database; 

      --add 29/06/17
	SELECT s.hostname,s.sid as ses
        INTO v_host,v_ses
	FROM sysmaster:syssessions s ,sysmaster:sysopendb b
	WHERE s.username = USER AND s.sid = DBINFO('sessionid') AND  
	      s.sid=b.odb_sessionid AND b.odb_iscurrent = 'Y';
     --end add 29/06/17

IF flag = 0			-- новая запись
….
ELSE BEGIN 
	SELECT count(*) INTO act_conn_x 
	FROM sysmaster:syssessions s, sysmaster:sysopendb o 
	WHERE s.username = USER 
	AND o.odb_dbname = my_database 
	AND o.odb_sessionid = s.sid; 

        --  add 29/06/17
        INSERT INTO sysdbopenusr 
	VALUES (USER,CURRENT year to second,null,my_database,v_host,v_ses);
       --end add 29/06/17
…..

select sid,username,hostname,dbinfo('UTC_TO_DATETIME',connected) as connected,feprogram,state 
,current - (dbinfo('UTC_TO_DATETIME',connected) + 1 UNITS HOUR) as duration
from syssessions

select * from syssessions = SELECT  * FROM sysopendb t2 {0}