DB2 Server for VSE & VM: Interactive SQL Guide and Reference

TAB

.-1-------. >>-TAB----+---------+------------------------------------------>< '-integer-'

TAB is an ISQL display command that enables you to view all the characters of a column that is too wide to fit on the display. It lets you display any adjacent characters of the column; the number of characters displayed is equal to the width of your display. Before issuing TAB, place the desired column at the left edge of the display.

integer

is the number that represents the character's position where the display is to start. If no number is specified, the display starts at the first character position of the column.

The TAB command is valid only for CHAR or VARCHAR columns.

Example

Suppose you are viewing a column whose length attribute is 100 characters. If you are using a 24 x 80 display and you want to view the characters beyond the 80th, you type:

   tab 81

This displays the column, starting with the 81st character at the left edge of the display.