DBNAME function

Returns, as a character string, the name of the logical database currently in use or the name of your first connected database.

Syntax

DBNAME

Example

This portion of a procedure defines a header frame to hold a date, page number, database name, and user ID:

r-dbname.p

DEFINE VARIABLE pageno AS INTEGER NO-UNDO FORMAT "zzz9" INITIAL 1.

FORM HEADER "Date:" TO 10 TODAY
  "Page:" AT 65 pageno SKIP
  "Database:" TO 10 DBNAME FORMAT "x(60)" SKIP
  "Userid:" TO 10 USERID WITH NO-BOX NO-LABELS.
VIEW.

Notes

• The AVM returns the database name in the same form you used when you connected to the database. If you used a fully qualified pathname, the AVM returns the full directory pathname (such as /usr/acctg/gl on UNIX or C:\acctg\gl in Windows). If you used a name relative to your current working directory, then the AVM returns that name (for example, gl).
• Unless you define a format, the database name is displayed in a character field with the default format of x(8).
• A database must be connected in order for the DBNAME function to work as described.

See also

ALIAS function, CONNECT statement, CONNECTED function, CREATE ALIAS statement, CREATE CALL statement, DATASERVERS function, DBVERSION function, DELETE ALIAS statement, DISCONNECT statement, FRAME-DB function, LDBNAME function, NUM-DBS function, PDBNAME function, SDBNAME function