Re: Capturing Database Name

[Bill Beckner <Bbeckner@ICC.CC.IL.US>]

My $0.02 worth - I just tested the $Username scenario in our DB2/Unix (AIX)
environment, and the $Username variable only contains the user name used to
log into the database.  Since we are a PeopleSoft customer, I've been
acquiring the database name from the PSDBOWNER table.

--
William Beckner -- Stunt Programmer
Illinois Central College, Rm L141 -- East Peoria, IL  61635-0001
PH: (309) 694-8419 -- FAX: (309) 694-8995
"C code.  C code run.  Please, code, RUN!"


-----Original Message-----
From: Ivory, Wayne [mailto:wayne.ivory@ILUKA.COM]
Sent: Tuesday, August 24, 1999 7:36 PM
To: Multiple recipients of list SQR-USERS
Subject: Re: Capturing Database Name


Rhonda,

Believe it or not, $USERNAME contains the database name (at least in my SQR
3 over Informix environment it does).

Wayne Ivory
Information Services
Iluka Resources Limited


-----Original Message-----
From: Rhonda Handley [mailto:Rhonda_Handley@HCM.HONDA.COM]
Sent: Wednesday, 25 August 1999 03:44
To: Multiple recipients of list SQR-USERS
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