HP (Hewlett-Packard) c-tree-SQL ISQL and Tool reference Guide Printer User Manual


 
ISQL and Tools
3-42 FairCom Corporation
lot_id NOT NULL INT 4
purity DOUBLE 8
p_deviation DOUBLE 8
strength DOUBLE 8
s_deviation DOUBLE 8
comments CHAR 200
ISQL> table samples
COLNAME NULL ? TYPE LENGTH
------- ------ ---- ------
lot_id INT 4
samples INT 4
comments CHAR 200
ISQL>
3.7.23 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 dis-
play; CENTER centers the text; RIGHT aligns the text to the right (with the right-most charac-
ter 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 the specified number of lines after a TOP title is printed and before a BOTTOM title is
printed. By default, ISQL does not skip any lines.