Defining Your Relational View

Use the Browse menu Relational Views command from the Schema Browser to develop a relational view of the current schema. This relational view then enables you to access Jade data using SQL select statements by the Jade Open Database Connectivity (ODBC) driver.

Each schema within the Jade database can have a collection of relational views.

A memory-based copy of your relational view is created by the Relational View Wizard and developed at each step of the process. The generation of class features and the saving of the view are the most time-intensive steps of the Relational Views wizard. A large schema the size of the Jade schema should take only a few seconds for these steps.

The Relational Views Browser enables you to maintain your relational views only. To access the Jade data in the relational view using SQL select statements, you must first write your own inquiry programs. For details, see "SQL Examples", in Chapter 2 of the External Interface Developer’s Guide.

To open a Relational Views Browser window, perform one of the following actions

Select the Relational Views command from the Browse menu
Press Ctrl+O

A Relational Views Browser window is then opened.

If you have not yet defined a relational view, nothing is displayed in the Relational Views Browser.