Re: database and server names
Paul,
to get the servername, try:
select distinct sitename
from systables
where tabid = 1;
as far as getting the current database name, ... well this has been a request of
mine for many years and as far as i know there is no built in way to do it. you
can create a table in each database that holds the database name (name the table
the same in all databases) and then select from the table.
regards,
bob baskett
_______________________________________________________________________________
Subject: database and server names
From: watjep@ns.netxpress.com@smtpsend at #EMAIL
Date: 4/3/96 10:07 PM
Apparently-To: RZBJ40@email.sps.mot.com
Is there are way in 4GL to determine the current database and server
name of the system? Any solution would be of great help.
+-------------------------------------------------------------------+
| Paul K. Watje 4GL/Fourgen Programmer |
| AEC Data Systems UNIX system administator |
| San Antonio, TX Database Administrator |
| watjep@NetXpress.com Blah, Blah, Blah, Blah |
+-------------------------------------------------------------------+