Getting Started › DBSQLPR › Line Commands

Line Commands

The following in-line commands are accepted by DBSQLPR in your input file:

DROP PLAN auth-id.plan-name

You can submit a DROP PLAN statement in Version 12 and above as an in-line command in DBSQLPR by using DROP PLAN auth-id.plan-name (where auth-id is an optional authorization ID, followed by a period, and the plan-name is the required name of the plan you want to drop).

We recommend that you do not use DROP PLAN to drop plans related to procedures. and functions. Use the DROP PROCEDURE statement and DROP FUNCTION statements to drop procedures.

For more information about DROP PLAN, see DROP PLAN (DBSQLPR).

--

Two dashes at the start of any line causes the line to be interpreted as a comment and ignored.

*

An asterisk at the start of any line causes the line to be interpreted as a comment and ignored, unless that line contains one of the following line commands that begin with an asterisk:

*$COLUMN (or *$C)

Specifies one data item per line of output (same as *$THIN).

*$PAGE (or *$P)

Generates a form-feed and page-header.

*$ROW (or *$R)

Specifies tabular output with column headings truncated to width of data.

*$THIN (or *$T)

Specifies one data item per line of output (same as *$COLUMN).

*$WIDE (or *$W)

Prints output in tabular form, reverting to *$THIN if data exceeds PRTWIDTH= specification.

*$ZERO (or *$Z)

Zeroes the job-step return code.