Home | Previous Page | Next Page   The Database Option >

Displaying Database Information

Use the Info option on the DATABASE menu to display information about dbspaces and nondefault locale settings and to read the body of routines in the current database.

Tip:
This menu option provides information about the database that the SQL statement INFO does not display.

When you select the Info option on the DATABASE menu, the SELECT DATABASE screen appears, as Figure 26 shows.

After you select a database, the DATABASE INFO menu appears, with the database you selected identified in the dashed line.

Figure 32 shows the DATABASE INFO menu for IBM Informix Dynamic Server.

Figure 32. The DATABASE INFO Menu for IBM Informix Dynamic Server
DATABASE INFO: dBspace  Nls  Routine  Databases  Exit
Display DBSPACE information for a database.

------------ demodb@dbserver1 ------- Press CTRL-W for Help -----

The DATABASE INFO menu displays the following options.

Option Purpose Instructions
dBspace Retrieves information about the dbspaces in the current database. Retrieving Information on Dbspaces
NlS Displays Native Language Support (NLS) settings for a database that supports NLS. This option is provided for compatibility with legacy database versions that support NLS. Retrieving Nondefault Locale Information
Procedures
(XPS only)
Lists the procedures in the current database. Select a procedure name to see the statements in the body of that procedure. Retrieving Information on Routines
Routine
(IDS only)
In Dynamic Server, the routine option lists the procedures and functions in the current database. Select a routine name to see the body of that routine as text. Retrieving Information on Routines
Databases Selects a different database about which to retrieve information. Selecting a Different Database
Exit Leaves the DATABASE INFO menu and returns you to the DATABASE menu. none

To leave the DATABASE INFO menu without displaying information about the current database, press the Interrupt key to return to the DATABASE menu.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]