Database name in 7.11 Online
Posted in 1996
cherylk@spamis.jcdc.doleta.gov — — source: Informix-list mailing list archive (1991-1998)
Using Informix Online 7.11 UC1 how can you get the database name for the
database you are presently in?
I know that all database names are held in the sysdatabases system table
of the sysmater database, yet I want to return my present database name
like I can todays date or my user id. Like:
Select current from systables where tabid=1; This would return todays date and time.
Is there a way to:
Select database_name from systables where tabid=1; That would return the present name of the database?
Thanks in advance
Cheryl L. Kendricks
E-mail: cherylk@spamis.jcdc.doleta.gov