Database - Views Tab


In BBj 13.0 and higher, the Enterprise Manager Java app has been superseded by a new browser Enterprise Manager and Eclipse plug-in. See Enterprise Manager - Database: Views.

Views allow the database administrator to create "views" of the database that appear to the user as another table, but can be arbitrarily complex in the information they present.

To create a view

1. Select the desired database from the "Databases" list.

2. Click on the Views tab.

3. Click on the [Add New View] button.

To edit a view

1. Select the desired database from the "Databases" list.

2. Click on the Views tab.

3. Select the appropriate view from the list.

4. Click on the edit view button.

The view editor dialog is very simple and contains two items: name, and SELECT statement. The name of the view is the name that users will use when they want to refer to the view in a query. The SELECT statement is the query that will be run when users refer to the view. For example:

em-vieweditor.png

The OPENINV view shown above performs a join between two tables and includes a WHERE clause. A user accesses this view using a simple SELECT statement:

SELECT * FROM openinv

When this statement is executed, internally it executes the view statement and treat its results as if it were a single table.

See Also

Configuration

Information Tab

Tables Tab

Procedures Tab

Type Definitions Tab

Sequences Tab

Permissions & Roles Tabs

SQL Tab

Query Analysis Tab



______________________________________________________________________________________

Copyright BASIS International Ltd. BBj®, Visual PRO/5®, PRO/5®, and BBx® are registered trademarks.