How to Use JRS

As soon as the system has started you can use an existing database or to create a new one. Existing databases are listed in the Metadata Browser window.

Once a database has been selected, you can see the database schema and the system catalog tables using the browser window.

Once a database schema is created or updated, you must restart the browser application, with Show Database Browser in the File menu, for the new definitions to be visible.

To use a database you may select it from the browser or type the following statement in the Input Window:

CONNECT DatabaseName;

Note that an SQL statement is terminated by a semicolon. SQL keywords do not have to be entered in upper-case letters; lower-case may also be used. Database, tables and attribute names are case sensitive.

You can enter SQL statements in three ways:

The results of SQL statements are displayed in the Output Window. The content of this window cannot be edited, but it can be selected and copied, or saved into a file with the command Save from the File menu.

A set of SQL statements for the sample database SportDB is available in the page SQL By Examples of the Help index.

The following list describe the function of each button of the JRS interface:

The following list describe the function of each menu at the top of the JRS interface:

Once you have loaded data in a new or predefined database, update statistics used by the optimizer with the command: UPDATE STATISTICS

 

Index Page