Example SQL: dbwho.sql
select sysdatabases.name database, -- Database Name
syssessions.username, -- User Name
syssessions.hostname, -- Workstation
syslocks.owner sid -- Informix Session ID
from syslocks, sysdatabases , outer syssessions
where syslocks.tabname = "sysdatabases" -- Locks sysdatabases
and syslocks.rowidlk = sysdatabases.rowid -- Join to database
and syslocks.owner = syssessions.sid -- Use session ID