ISQL Statements
The following example also issues two more DISPLAY statements to display the variable val- ues. As before, the DISPLAY statements must specify the customer_name break. They also indent their display farther to indicate the relationship with the previously issued DISPLAY.
As before, this example uses the COLUMN and DISPLAY statements from previous exam- ples. ISQL processes DISPLAY statements in the order they were issued. Use the DISPLAY statement, without any arguments, to show the current set of DISPLAY statements in effect.
Also, in the query results, notice that the column formatting specified for the order_value col- umn carries over to the tot_value variable, which is based on order_value.
Example
ISQL> compute count of order_id in | num_orders | on | customer_name | ||||||
ISQL> compute sum | of order_value in tot_value | on | customer_name | ||||||
ISQL> display col | 10 | "Total | number | of | orders:", num_orders | on customer_name; | |||
ISQL> display | col | 10 | "Total | value of orders:", tot_value on customer_name; | |||||
ISQL> display | See all the DISPLAY | statements | currently | active: | |||||
display | col 5 | "Summary of activity for" | ,customer_name on customer_name | |||
display | col | 10 | "Total | number of orders:" ,num_orders | on customer_name | |
display | col | 10 | "Total | value of orders:" | ,tot_value | on customer_name |
ISQL> select c.customer_name, c.customer_city, o.order_id, o.order_value
from customers c, orders o |
|
| |||
where o.customer_id = | c.customer_id |
| |||
order by c.customer_name; |
|
| |||
CUSTOMER_NAME |
| CUSTOMER_CITY | ORDER_ID | ORDER_VALUE | |
| |||||
Aerospace Enterpris | Scottsdale | 13 | $3,000,000.00 | ||
Aerospace Enterpris | Scottsdale | 14 | $1,500,000.00 | ||
Summary of | activity | for Aerospace Enterpris |
| ||
Total | number of orders: | 2 |
| ||
Total | value of | orders: | $4,500,000.00 |
| |
Chemical Constructi | Joplin | 11 | $3,000,000.00 | ||
Chemical Constructi | Joplin | 12 | $7,500,000.00 | ||
Summary of | activity | for Chemical Constructi |
| ||
Total | number of orders: | 2 |
| ||
Total | value of | orders: $10,500,000.00 |
| ||
Luxury Cars Inc. |
| North | Ridgeville | 21 | $6,000,000.00 |
Luxury Cars Inc. |
| North | Ridgeville | 20 | $5,000,000.00 |
Summary of activity for Luxury Cars Inc.
Total number of orders: | 2 |
Total value of orders: $11,000,000.00
.
.
.
3.4.3Adding Beginning and Concluding Titles with the TITLE Statement
You can add some finishing touches to the query display with the TITLE statement.
FairCom Corporation |
