APPEND CLPPlus command
The APPEND CLPPLus command adds text to the end of the current line in the SQL buffer. You can use this command to build commands and statements in the SQL buffer.
Invocation
This is a line editor command and can be used to build commands in the SQL buffer.
Authorization
None
Required connection
None
Command syntax
Command parameters
- text-string
- Specifies a string of characters to append. The string can include spaces and special characters. The case of the string is preserved.
Examples
In the following example, the APPEND command
appends the string this text is appended.
to the
end of the current line in the SQL buffer:
APPEND this text is appended.
The
following example shows how you can use the APPEND command
to build a SELECT statement in the SQL buffer. Two spaces are placed
between the APPEND command and the WHERE clause
to separate DEPT
and WHERE
by one
space in the SQL buffer.
SQL> APPEND SELECT * FROM DEPT
SQL> LIST
1* SELECT * FROM DEPT
SQL> APPEND WHERE DEPTNO = 10
SQL> LIST
1* SELECT * FROM DEPT WHERE DEPTNO = 10
The LIST command
displays the contents of the SQL buffer as the SQL statement is being
built.