CLEAR CLPPlus command

The CLEAR CLPPlus command removes the contents of the SQL buffer, deletes all column definitions set by the COLUMN command, or clears the screen.

Invocation

You must run this command from the CLPPlus interface.

Authorization

None

Required connection

None

Command syntax

Read syntax diagramSkip visual syntax diagramCLEARCLSCRSCREENBREAKSONcolumnBREONcolumnBUFFERBUFSQLCOLUMNSCOLCOMPUTESONcolumnCOMPONcolumnVARIABLESVAR

Command parameters

SCREEN | SCR
Removes all SQL commands, data currently displayed, and CLPPlus messages from the screen. When the CLEAR command is entered with no options, the default behavior clears the screen.
BREAKS | BRE ON column
Clears all breaks when no column is specified. When a column is specified, the break associated with that column is cleared, all other breaks are left intact.
BUFFER | BUF and SQL
Deletes all text in the SQL buffer. You must specify both the BUFFER parameter (or the BUF parameter) and the SQL parameter.
COLUMNS | COL
Removes column definitions in the SQL buffer.
COMPUTES | COMP ON column
Clears all compute definitions when no column is specified. When a column is specified, the compute definition associated with that column is cleared, all other compute definitions are left intact.
VARIABLES | VAR
Clears all defined bind variables.