Re: SQL for current database

Rick Ward wrote: > > Can anyone supply me with some SQL to run against Online V7.13, which > will return the name of the database this session is currently > connected to ? > > --- > Rick Ward > Senior DBA > Great Universal Stores Home Shopping > MANCHESTER, UK > > All views and comments in this e-mail are expressed by myself only, and > are not necessarily representative of my employer, Great Universal > Stores. Hi Rick, have a look inside your $INFORMIXDIR/etc/sysmaster.sql file. There you will find a table called "sysopendb" which contains the "odb_sessionid" as well as "odb_dbname" and additional informations that you will receive by "onstat -g sql". Bye Stefan PS: select odb_dbname from sysmaster:syssessions as a,sysmaster:odb_sessionid as b where a.sid = b.odb_sessionid; I gave you "syssessions" just to find out your current program.