dbname in user???

tushar149 · #1 (**permalink**) 09-13-06, 02:24

How to find which database is currently in use?? Is there any command to find out...Like in SQL Server there is command called db_name() which returns the current database in use or selected..Please help its and urgent requirment.

Marcus_A · #2 (**permalink**) 09-13-06, 02:49

select current server from sysibm.sysdummy1;

tushar149 · #3 (**permalink**) 09-13-06, 07:43

Hi,

THanks for ur Prompt reply. My propblem is solved.. Thanks very much.

grofaty · #4 (**permalink**) 09-13-06, 08:03

Hi,
one more solution:

Code:

values (current server);

Internet Services

Web Development

Digital Marketing

Consumer Tech