The Database Browser

About the Interface

Area	Description
Menu Bar	Pulldown menu options.
Servers	All Database Servers on the network known to the Sapphire/Web Gateway. When a Database Server is selected, all of the databases associated with that server are displayed in the Databases list. Oracle users should always select the ORACLE server. The format is: server_name (vendor) where vendor is one of SYB (Sybase), ORA (Oracle), and INF (Informix)
Databases	A list of all databases on the selected server. When a database is selected, the Titles/Views and Objects lists are filled. Oracle users see a list of Database Connection Strings for the databases known to the Sapphire/Gateway.
Tables/Views	All of the Tables and Views known to the selected database. When a Table is selected, the Columns list is populated. Oracle also displays the user's Synonyms, but does not display the System Tables, Views or Synonyms. The format for Tables is: owner.table_name (type) where type is: U = User Tables V = Views S = System tables (for Oracle it means Synonym)
Columns	This list contains information about each of the columns that comprise the select Table. The format of the Column is: column_name -> data_type(dimension) (NULL Status)
Data Object Type	Choose between viewing Stored Procedures and DSQL Objects.
Objects	This is a list of all the Stored Procedures or DSQL Objects associated with the selected database. When an Object is selected, the Arguments list is populated.
Arguments	All arguments for the selected Object. Content varies by Database Vendor and the Object Type being displayed. The name of the argument is always shown.

Pulldown Menus

File

Option	Description
Close	Closes the interface.

View

Option	Description
Hide Servers	A toggle button used to hide/show the Servers list.
Hide Databases	A toggle button used to hide/show the Databases list.
Tables >	This is a cascading menu with the following options: Hide Table List - A toggle button used to hide/show the Tables list. Hide System Tables - A toggle button used to hide/show the system tables displayed in the Tables list. Oracle hides/shows synonyms. Hide User Tables - A toggle button used to hide/show the user tables displayed in the Tables list. Hide Views - A toggle button used to hide/show the views displayed in the Tables list.
Columns >	This is a cascading menu with the following options: Hide Column List - A toggle button used to hide/show the Columns list. Hide Data Types - A toggle button used to hide/show the column data type and dimension in the Columns list. Hide NULL Status - A toggle button used to hide/show the column's NULL status in the Columns list.
Hide Objects	A toggle button used to hide/show the Objects list.
Hide Arguments	A toggle button used to hide/show the Arguments list.

Tools

Option	Description
Network Object Browser	Invokes an instance of the Database Browser.
Network Object Editor	Invokes an instance of the Object Editor.
Modify Table Data	Invokes the Table Data Editor for the selected Table. This interface allows the user to insert, update and delete data in the selected Table.

Help

Option	Description
About	Displays the About Sapphire/Web Dialog.
Interfaces	Provides on-line help for the Database Browser interface.

Pop-up Menus

Browser List

Option	Description
Hide...	Each list has a pop-up menu that will hide the list with which it is associated. To show the hidden list, the pulldown menu must be used. The Table and Column pop-ups are equivalent to those on the View pulldown menu.

How to Invoke the Interface