|
|
|
TITLE
Syntax
TITLE [
[ TOP | BOTTOM ]
[ [ LEFT | CENTER | RIGHT | COL n ] " text " ] [ ... ]
[ SKIP n ]
] ;
Description
The TITLE statement specifies text that ISQL displays either before or after it processes a query. TITLE with no arguments displays the titles currently set, if any.
Arguments
TOP | BOTTOM
Specifies whether the title is to be printed at the top or bottom of the page. The default is TOP.
LEFT | CENTER | RIGHT | COL n
Specifies the horizontal alignment of the title text: LEFT aligns the text to the left of the display; CENTER centers the text; RIGHT aligns the text to the right (with the right-most character in the column specified by the SET LINESIZE statement). COL n displays the text starting at the specified column (specifying COL 0 is the same as LEFT).
The default is LEFT.
" text "
The text to be displayed.
SKIP n
Skips n lines after a TOP title is printed and before a BOTTOM title is printed. By default, ISQL does not skip any lines.
Examples
The following example shows the effect of specifying a top title without a bottom title, then both a top and bottom title.
ISQL> TITLE "fred"
ISQL> select * from syscalctable;
fred
FLD
---
100
1 record selected
ISQL> TITLE BOTTOM "flintstone"
ISQL> select * from syscalctable;
fred
FLD
---
100
flintstone
1 record selected
The TITLE statement can specify separate positions for different text in the same title:
ISQL> CLEAR TITLE
ISQL> TITLE TOP LEFT "Align on the left!" CENTER "Centered text" RIGHT "Right aligned text!"
ISQL> select * from syscalctable;
Align on the left! Centered text Right aligned text!
FLD
---
100
1 record selected
