TTITLE CLPPlus command

The TTITLE CLPPlus command inserts text at the top 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 diagramTTITLE,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 after the top 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 top of every page. One blank line follows the top title.

SQL> BREAK ON workdept SKIP PAGE;
SQL> COLUMN workdept NEW_VALUE new_dept;
SQL> TTITLE LEFT 'DEPT: ' new_dept, CENTER 'CONFIDENTIAL', RIGHT 'Page No: ' PGNO SKIP 1;

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

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