How to select a current "database_name" ? 2

[Rosti]

Hi.
Is it any way to write this kind of a statement:
SELECT "current_database_name"
FROM ....


Thanks in advance.
Rostik

 

[olded]

Rosti:

Here's a trick I learned from Jonathan Leffler, the heavy-weight of all Informix heavy weights:

SELECT ODB_DBName
FROM SysMaster:"informix".SysOpenDB
WHERE ODB_SessionID = DBINFO('sessionid')
AND ODB_IsCurrent = 'Y';

SysOpenDb isn't a table, but a view into the SysMaster database.

Regards,


Ed

 

[Rosti]

Thank you very much for the responces.
Ed, your SELECT work just wonderfull !!!!!


Thanks again for help.

Rostik