[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: System Variable $username Returns Database Name
- Subject: Re: System Variable $username Returns Database Name
- From: Nathan Treadway <nathant@ontko.com>
- Date: Mon, 17 Feb 1997 17:48:22 -0500
- In-Reply-To: <9702142226.AA09048@ globalvision.net> from "Jim Wolfe" at Feb 14, 97 05:37:21 pm
> Ideally, I'd like to have a "$database" system variable, too, to be
> able to print on the report which database the report reflects.
What database server are you using? If oracle, I believe there's a
public-access table named GLOBAL_NAME from which you can get the SQL*Net
database name. I forget the details about which INIT.ORA setting that table
contains, but it will probably give you what you want.
Nathan
----------------------------------------------------------------------------
Nathan Treadway | Ray Ontko & Co. | info@ontko.com (auto-reply server)
nathant@ontko.com | Richmond, IN | ftp.ontko.com, http://www.ontko.com/