Using the Editing Keys

The editing keys listed at the top of the SQL editor screen perform the following special functions when you enter SQL statements:

CTRL-A

switches between insert mode and typeover mode. You are automatically in typeover mode when you begin to use the SQL editor.

• In insert mode, the text beneath the cursor shifts to the right as you enter new characters.
• In typeover mode, characters you enter replace the text beneath the cursor.

CTRL-D

deletes characters from the current cursor position through the end of the line.

CTRL-R

redraws the current screen. Use it when you receive an electronic message or some other interference that makes it difficult to read the SQL statement text that you enter.

CTRL-X

deletes a character beneath the cursor.

ESC

returns you to the SQL menu when you finish entering or editing the SQL statement. You can then run or modify the statement or select the system editor for more extensive editing.

CTRL-F

scrolls forward through the command history list. (XPS)

CTRL-B

scrolls backward through the command history list. (XPS)

For more information on arrow and cursor-positioning keys, see Using the Keyboard with DB-Access.