Displaying Lock-Sessions

Hi there, can anyone tell me why the following works in IDS 7.23 on SCO but not with IDS 7.3 on NT? database sysmaster;select UNIQUE l2.owner sessionid, s.username username, s.hostname hostname from syslocktab l1, syslocks l2 , systabnames t, syssessions s where current year to second - (datetime( 1970-01-01 00:00:00 ) year to second +lk_grtime units second + 2 units hour) > 60 units second and l2.tabname=t.tabname and t.dbsname="wfl" and t.partnum=l1.lk_partnum and l2.rowidlk=l1.lk_rowid and l2.owner=s.sid Thanks in advance Dirk -- -- Dirk Gunsthoevel IT Consulting phone: +49 (0)251 624947 -- Steinfurter Str. 61 fax: +49 (0)251 624177 -- 48149 Muenster mobile: +49 (0)170 5464715 -- Germany http://www.guncon.de/