BTITLE CLPPlus command

The BTITLE CLPPlus command inserts text at the bottom of each page displayed.

Invocation

You must run this command from the CLPPlus interface.

Authorization

None

Required connection

None

Command syntax

Read syntax diagramSkip visual syntax diagramBTITLE,CENTERLEFTRIGHTtextPGNOvariable-nameSKIPinteger-value

Command parameters

text
Specifies the text to be displayed.
CENTER
Specifies the display will center justify the text on each page. If neither CENTER, LEFT, or RIGHT is specified, center justification is the default behavior.
LEFT
Specifies the display will left justify the text on each page.
RIGHT
Specifies the display will right justify the text on each page.
PGNO
Specifies the current page number.
variable-name
Specifies a user defined variable that will follow the text field.
SKIP integer-value
The integer-value value specifies the number of blank lines displayed before the bottom title.

Example

In the following example, the DEPT: (with the variable contents), CONFIDENTIAL, and Page No: (with the current page number) is displayed across the bottom of every page. Three blank lines follows the bottom title.

SQL> BREAK ON workdept SKIP PAGE;
SQL> COLUMN workdept OLD_VALUE old_dept;
SQL> BTITLE LEFT 'DEPT: ' old_dept, CENTER 'CONFIDENTIAL, RIGHT 'Page No: ' PGNO SKIP 3;

In the following example, the Page No: title (with the current page number) is displayed across the bottom of every page with right justification. Two blank lines follow the bottom title.

SQL> BTITLE RIGHT 'Page No: ' PGNO SKIP 2;