Key functions commonly used in an INGRES_TERM.

As all Ingres subsystems are 'Form' based, the following list will be applicable throughout the Ingres environment:-

Ingres works in 'Frames'; all Frames consist of a 'Form' (i.e. Display screen area) and a menu line.

Use Function keys as labelled for Menu choice OR type first few identifying characters of option required.

KEY

Explanation

< RETURN > key

Move from MENU line to 'Form'

< F1 > (function key)

Move from Form to MENU line

< F1 > twice

To view more menu choices (denoted by > )

< F3 > i.e. End

Takes you back to previous Frame

< F4 > i.e. Quit

Takes you out of Ingres altogether;

TAB, Ctrl/P, or Cursor keys

Move across columns, (across to next field)

Ctrl/N

Moves down a line in a Table-field ;

Ctrl/E

Toggles edit mode between Insert/Overstrike (default is overstrike)

Make full use of the 'Keys' option within the 'HELP' facility from each Menu line.

FURTHER KEYSTROKES WHEN WORKING IN ISQL

Although the details given above apply equally well to the ISQL interface, it is also worth noting the following:

Do not type long SQL statements - they will wrap-around and are difficult to read/amend etc.

Start a few lines down from the top of the screen to allow insertion of extra statements if necessary.

Several ways to edit statements:

1)Choose the Edit option from the Menu line; this invokes the INED screen editor; to exit from this use <ALT>&<D> which returns you to the ISQL screen; 2)Choose the Lineditor from the Menu line which allows you to stay within the ISQL facility;

3)In simple cases use the Cursor and Delete keys.

It is worth spending some time familiarising yourself with this environment.

This WWW material is copyright De Montfort University and may only be reproduced or used if this copyright notice is included.