Filter
Top Products
ISQL and Tools
3-24 FairCom Corporation
Issuing the DISPLAY statement without any arguments displays the currently-set DISPLAY
specifications, if any.
Arguments
col_position
An optional argument that specifies the horizontal positioning of the associated display value.
There are two forms for the argument:
If the DISPLAY statement omits col_position, ISQL positions the display value at column 1.
display_value
The value to display when the associated break occurs:
break_spec
Specifies the set of rows after which ISQL processes the DISPLAY statement. A DISPLAY
statement has no effect until you issue a corresponding BREAK statement. See the description
of the BREAK statement in Section 3.7.2 "
BREAK" on page 3-13 for details of break specifi-
cations.
Examples
The following set of examples compute the number of orders placed by each customer and dis-
plays the message Number of orders placed by, followed by the customer name and the count
of orders.
ISQL> break on customer_name
COL column_number Directly specifies the column position of the display value as an
integer(1 specifies column 1, 2 specifies column 2, and so on.).
@column_name Names a column in the select list of the SQL query. ISQL aligns
the display value with the specified column.
"text string" If the display value is a text string, ISQL simply displays the text string.
variable If the display value is a variable, ISQL displays the value of the variable
when the associated break occurs. The variable argument refers to a vari-
able named in a COMPUTE or DEFINE statement that executes before
the query. If variable is undefined, ISQL ignores it.
column_name If the display value is a column name, ISQL displays the value of the col-
umn when the associated break occurs. The column specified in
column_name must also be included in the select list of the query. If
column_name is not also included in the select list, it has no effect. If a
COLUMN statement specifies a format for the same column, the format-
ting also affects the DISPLAY statement.