RE: [sqr-users] Want to know the database name

[apthornton@nisource.com]

If you want to, you can select the database name from the database, but I'm
fairly sure that the exact syntax is DB-dependant.  On Oracle, you can use
this:

BEGIN-SELECT
VS.NAME

      Move &VS.Name to $name

FROM V$DATABASE VS
END-SELECT


I think other databases have similar ways of doing this.

Allen Thornton


                                                                                
                                                       
                        "Alexander,                                             
                                                       
                        Steve"                 To:       
"'sqr-users@sqrug.org'" <sqr-users@sqrug.org>                                 
                        <Steve.Alexander       cc:                              
                                                       
                        @ci.sj.ca.us>          Subject:  RE: [sqr-users] Want 
to know the database name                                
                        Sent by:                                                
                                                       
                        sqr-users-admin@                                        
                                                       
                        sqrug.org                                               
                                                       
                                                                                
                                                       
                                                                                
                                                       
                        07/02/2003 01:53                                        
                                                       
                        PM                                                      
                                                       
                        Please respond                                          
                                                       
                        to sqr-users                                            
                                                       
                                                                                
                                                       
                                                                                
                                                       




When I'm running from the Peoplesoft process scheduler in version 8, its
command line includes the database name. The Stdapi-Init procedure calls
the
Get-Run-Control-Parms procedure, which puts that value in $database_name.
I
don't know about other versions of Peoplesoft.

-----Original Message-----
From: Chandra Yarlagadda [mailto:yarlagaddacs@rediffmail.com]
Sent: Wednesday, July 02, 2003 10:20 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Want to know the database name



Hi

I want to find out what database the user has logged in when
launching the SQR.

Any help is appreciated.

Thanks,
Chandra


___________________________________________________
Click below to experience Sooraj R Barjatya's latest offering
'Main Prem Ki Diwani Hoon' starring Hrithik, Abhishek
  & Kareena http://www.mpkdh.com

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users




_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users