Re: current database name

Posted in 2003

Fernando Nunes — Fri, 05 Dec 2003 16:36:02 +0000 — source: Usenet: comp.databases.informix

John David Adamski wrote: > We are on IDS 7.31 on a HPUX machine and have 5 databases and I have > some SQL that runs in dbaccess on most of them regularly. Its just a > report and it would be nice to know on the report which database this > one was generated. > > What is the SQL code that will identify the current database I am > running on? select * from sysmaster:syssqlcurses One of the fields is what you need. Regards.