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

Display Database Environment in Report Template

Started by abirkholz1, 02 Feb 2007 04:13:49 PM

Previous topic - Next topic

abirkholz1

I am trying to create a report template that will display the database environment (Oracle in this case) name at run-time.  Does anyone know how to get the database environment name displayed at run-time?

Thanks.

sir_jeroen

have you looked in the Oracle forums for the available sql functions?

abirkholz1

I thought there might be a default function available.  However, it is easy enough to create a query (select name from v$database;) and pass that information into the report.

Thanks.