Type commands in the Command section, and execute them by pressing the F9 function key.
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, type Ctrl+F+9.
If you still have trouble executing commands, set up the terminfo extension
file as described in “Shift and Ctrl Keys.”
Enter multiple commands by separating 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. Use the up and down arrow keys to scroll through the table names changing the highlighted table name. While the list appears, press Enter to insert the current table name into the command window at the cursor position. While the list appears, press F7 to see a list of columns for the highlighted table. Again, use Enter 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. |
You may need to define key sequences for Shift and Ctrl to be applied to the next key. This enables you, for example, to use Shift+<function key> or Ctrl+PgDn key sequences.
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 sends 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.
These sequences are controlled by a terminfo extension (.tix) file. dbisqlc first looks for ${TERM}.tix in ${HOME}, /opt/IQ-15_1/tix, /opt/IQ-15_1/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.
