Function keys

First Guide to SQL Anywhere Studio
PART 2. Getting Results with SQL Anywhere Studio
CHAPTER 5. Using Interactive SQL

Function keys

Interactive SQL uses some function keys and special keys as follows:

Function key

Description

f1

Help

f5

Move data to the left by one column in the data window

shift+f5

Move data to the left by one character

f6

Move data to the right by one column

shift+f6

Move data to the right by one character

f7

Display a list of the tables in the database. The cursor up and down keys can be used to scroll through the table names changing the highlighted table name. With the list displayed, pressing enter will insert the current table name into the command window at the cursor position. The f7 key can be used while the table list is displayed, and a list of columns will be displayed for the highlighted table. Again, enter can be used to select the highlighted column name and put it into the command window at the cursor position.

f9

Execute the command that is in the command window. This operation can also be performed with the mouse by clicking Execute.

f10

Activate the menus

pgup

Move data up a page

pgdn

Move data down a page

ctrl+pgup

Move to top of data

ctrl+pgdn

Move to bottom of data

Function key	Description
f1	Help
f5	Move data to the left by one column in the data window
shift+f5	Move data to the left by one character
f6	Move data to the right by one column
shift+f6	Move data to the right by one character
f7	Display a list of the tables in the database. The cursor up and down keys can be used to scroll through the table names changing the highlighted table name. With the list displayed, pressing enter will insert the current table name into the command window at the cursor position. The f7 key can be used while the table list is displayed, and a list of columns will be displayed for the highlighted table. Again, enter can be used to select the highlighted column name and put it into the command window at the cursor position.
f9	Execute the command that is in the command window. This operation can also be performed with the mouse by clicking Execute.
f10	Activate the menus
pgup	Move data up a page
pgdn	Move data down a page
ctrl+pgup	Move to top of data
ctrl+pgdn	Move to bottom of data

Function keys for UNIX Interactive SQL

Interactive SQL on UNIX may be run on a variety of terminals. Some terminals prevent the Interactive SQL utility from distinguishing the Alt and Esc keys, and the function keys. This section describes alternatives in these situations.

ALT key On terminals for which the alt key is not supported in Interactive SQL, to enter an alt- key, use ctrl-a followed by the key to which the alt modifier is to be applied. For example, to see the File menu, type ctrl-a f.

If you are using Interactive SQL from a remote terminal such as a vt100 emulator you may be able to configure the terminal to use emacs mode so that it sends alt-key as esc key. Interactive SQL also recognizes these escape sequences. You can type esc key yourself but they must be typed in quick succession otherwise the keys are interpreted individually.
Function keys On terminals for which function keys do not appear to be supported in Interactive SQL, you can use ctrl-f followed by a single digit for the function key number. For example, you can enter f4 by typing ctrl-f 4.
Shift and Ctrl keys If necessary, key sequences can also be defined for shift and ctrl to be applied to the next key (so that shift-FunctionKey or ctrl-pgdown can be entered). These sequences are controlled by a terminfo extension (tix) file.

Interactive SQL first looks for ${TERM}.tix in ${HOME}${ASANY} / tix, ${ASANY} /bin, and then throughout PATH. If $TERM.tix is not found, Interactive SQL searches for default.tix in the same directories.