Type commands in the Command section, and execute them by pressing the F9 function key on UNIX or the Execute button on Windows.
If your terminal does not support the function keys,
type CTRL-F followed by the function key number. For example, for
the F9 function key, you would type CTRL–F
9. If you still have trouble executing commands, set up the terminfo
extension file as described in “Shift and Control Keys.”
To enter multiple commands at once, separate them with semicolons.
You can store commands to an ASCII file by typing CTRL-A F to activate the File menu, and using the down arrow to choose File > Save from the menu bar.
To load from an ASCII file, type CTRL-A F and choose File > Open from the menu bar.
dbisqlc uses some function keys and special keys on UNIX as described in Table 2-6.
Function key |
Description |
|---|---|
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 up and down arrow 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. |
CTRL+PgUp |
Move to the top of data |
CTRL+PgDn |
Move to bottom of data |
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).
Some terminals do not allow dbisqlc to distinguish when the ALT key is being used. To enter an ALT- key in dbisqlc, 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 use dbisqlc from a remote terminal, such as a VT100 emulator, you may be able to configure the terminal to use “emacs mode” so that it will send ALT-<key> as ESC <key>. dbisqlc will also recognize these escape sequences. You can type ESC <key> yourself, but they must be typed in quick succession or the keys will be interpreted individually.
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. The dbisqlc utility first looks for ${TERM}.tix in ${HOME}, /opt/ASIQ-12_7/tix, /opt/ASIQ-12_7/bin, and then throughout ${PATH}. If ${TERM}.tix is not found, dbisqlc searches for default.tix in the same directories. A sample default.tix file comes with Sybase IQ.
