INPUT CLPPlus command

The INPUT line-editor command adds a line of text to the SQL buffer after the current line.

Invocation

You must run this command from the CLPPlus interface.

Authorization

None

Required connection

None

Command syntax

Read syntax diagramSkip visual syntax diagramINPUTItext

Command parameters

text
Specifies the text to be inserted into the SQL buffer.

Example

In the following example, the sequence of INPUT commands constructs a SELECT statement, which is displayed by the LIST command:

SQL> INPUT SELECT empno, ename, job, sal, comm
SQL> INPUT FROM emp
SQL> INPUT WHERE deptno = 20
SQL> INPUT ORDER BY empno
SQL> LIST
  1  SELECT empno, ename, job, sal, comm
  2  FROM emp
  3  WHERE deptno = 20
  4* ORDER BY empno