PRINT CLPPlus command

The PRINT CLPPLus command displays the value of a bind variable. Bind variables are used in place of literal values. If you issue a SELECT statement multiple times, you can use bind variables to reduce the number of literal values.

Invocation

You can run this command in the CLPPlus interface.

Authorization

None

Required connection

You must be connected to a database.

Command syntax

Read syntax diagramSkip visual syntax diagramPRINTPRIbind-variable-name

Command parameters

bind-variable-name
Specifies a string of characters that can include spaces and special characters. If you do not specify bind-variable-name, the values of all bind variables are printed.
If bind-variable-name is of the datatype REFCURSOR, the result set pointed to by bind-variable-name will be read in its entirety and all the rows will be printed following the report formatting specified in the current CLPPlus session.