.-1-------. >>-LEFT----+---------+----------------------------------------->< '-integer-' |
LEFT is an ISQL display command that causes the display to start integer columns to the left, counting from the leftmost column on the display and as long as no columns are being excluded. The number refers to the columns provided by the SELECT statement, not those currently displayed. You must use the order of the columns specified in the SELECT clause of the SELECT statement that provided the query result to determine the value to specify for integer. If the value of integer represents a column being excluded, the display starts at the next displayable column to the right of the excluded column.
Specifying a value greater than the number of columns remaining to the left, starts the display at column 1 or at the first displayable column if column 1 is excluded.
If no number is specified, the display moves one column to the left. No change in the display occurs if that column is excluded.