More on INGRES...

The database filename that we will be using for the class is entitled personnel. It can be accessed using INGRES with the query language of your choice (SQL or QUEL) as follows:

-- For those who wish to use SQL, use the following command:

sql personnel

-- For those who wish to use QUEL, use the following command:

quel personnel

Once in INGRES, you may enter your queries as described in the manual/book you are using for that query language with the additional requirement that you provide the command \go (or simply \g) after any command sequence in order to execute it.

Also, on line help is available inside INGRES by typing the following:

help help\g

To exit INGRES, you enter \quit (or simply \q), or just press CTRL-D.

One of the best ways to query INGRES about the database is to create a script of commands in a file using a text editor and then redirect input for INGRES to that file. For example, if you create a script file called test containing SQL commands for the database personnel, you can execute them as follows:

sql personnel <test

and similarly for a script file containing QUEL commands:

quel personnel <test

For more information on INGRES, see the reference manuals held by the system administrator, or post your question with the newsgroup utep.cs.database.