[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Capturing Database Name

If you are using Oracle Database you can do it by checking the database name in PSDBOWNER or V$Database table. Otherwise you can do it from the appropriate System Catalogue Tables.
 
Kris
----- Original Message -----
From: Rhonda Handley
To: Multiple recipients of list SQR-USERS
Sent: Tuesday, August 24, 1999 12:44 PM
Subject: Capturing Database Name

Is it possible to access the database name within an SQR program?
We refresh our test databases with a copy of our production database when
necessary.  I wrote a quick little program to zap out some of the sensitive
data.  Now I want to put in a check to make sure someone doesn't run this
against production by mistake.  I figure I can just check the database name
(datasource in the SQRW box).
Thanks
Rhonda Handley