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

COLUMN

.-1-----------------------. >>-COLumn----+-------------------------+----------------------->< '-position_in_select_list-'

COLUMN is an ISQL display command that displays the query result to be formatted so that it begins with the specified column at the left edge of the display.

blank

causes column 1, or the first displayable column if column 1 is being excluded, to be displayed at the left edge of the display.

position_in_select_list

is the number of the specified column.

The number refers to the columns provided by the SELECT statement, not those currently displayed. You must choose a number that represents the desired column's position in the SELECT clause of the SELECT statement that provided the query result.

If the value of position_in_select_list represents a column being excluded, the display starts at the next column to the right that is not being excluded. If there are no more displayable columns to the right, a blank display is the result.

Specifying a value greater than the number of columns in the query result displays the last column or a blank display if the last column is being excluded.