If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Displaying Databse name in the report footer

Started by dipstm, 18 Nov 2008 01:09:53 AM

Previous topic - Next topic

dipstm

Hi All,
I have a report in which at the page footer I want to display the database name.
How can I achieve this?
Thanx in advance.


Suraj

for sql server: db_name()
for oracle: SYS_CONTEXT('USERENV','DB_NAME')
or,
select substr(global_name,1,instr(global_name, '.',1)-1) "DB Name"  from global_name