Interactive SQL

In this section you will learn how to use the interactive SQL (isql) environment.

This section will use a paper based SQL TRAINER developed by Terry Sherwood and Nigel Roberts. This trainer covers use of the SQL select, insert, update, and delete commands. If you do not have access to this trainer please refer to suitable alternative. Hopefully this stuff will come on-line soon.

This environment is accessible from INGRES/MENU under the Queries option.

To enter the isql environment:

1. Using the cursor keys, scroll down to the Queries option.
2. Press F8 to Select (or start) the application.

This takes you to the Queries sub-menu which looks like this.

Now start the SQL option, again using F8 to Select (or start) the application.

This will start the isql application in which you can type sql commands and run them interactively.

The first thing you need to do when you enter the isql environment is to type the following commands:

• commit;
• set autocommit on;

Remember that the semi-colon is used to show the end of an SQL command.

When you have typed these commands you need to run them. To do this press the F8 key.

Ingres will show you the result of running the commands. You then need to press F3 to return to the sql screen.

At this point revert to the paper based SQL TRAINER developed by Terry Sherwood and Nigel Roberts.

Continue with trainer