Sent: Wednesday, August 25, 1999 5:11
AM
Subject: Re: Capturing Database
Name
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