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

RE: [sqr-users] print DATABASE name on report

Keep in mind that this is only sufficient for Oracle and DB2.

Also note that the database user PS owns the PSDBOWNER table, not SYSADM
like the other PeopleSoft objects.  So if there is no public synonym to
PSDBOWNER, it must be fully qualified as PS.PSDBOWNER.

Tracy E. Barnes
Ciber Enterprise Solutions
Principal Consultant
USA +1 (317) 374-7356
UK +44 (0) 7952 968447


-----Original Message-----
From: Yuri Lakef [mailto:lakef250@yahoo.com] 
Sent: Wednesday, 24 September, 2003 4:39 AM
To: sqr-users@sqrug.org
Subject: Re: [sqr-users] print DATABASE name on report

In PeopleSoft, you may...
 
SELECT DBNAME
    let $dbname = &DBNAME
FROM PSDBOWNER
 

"Bummer, Antonio" <ABummer@calwater.com> wrote:
I need to pint the DATABASE name on a SQR report. Is there any system
variable to accomplish this? 

SQR version 4.3.2 , MS SQL Server;


Thanks in advance..
Antonio

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

---------------------------------
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

_______________________________________________
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