Re: Capturing Database Name

[Cindy Chen <sxc4@rabbit.INS.CWRU.Edu>]

The database name is in the reserved variable $Username.  I actually
learned about this from the list and tested it in my environment(MVS/DB2).
Thanks to
all those contributed to the list.

Cindy
At 02:36 PM 8/24/99 -0700, Kris Narravula wrote:
>   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
>  I wrote a quick little program to zap out    some of the sensitive
>  Now I want to put in a check to make sure    someone doesn't run this
>  I figure I    can just check the database name
>(datasource in the SQRW    box).
>Thanks
>Rhonda Handley
>
>