NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
H-4
Considerations—HELP TEXT
text-line
is a line of help text in the form of a string of single-byte or multibyte characters
enclosed in single or double quotation marks. The string can be 0 to 132 bytes long,
but SQL issues a warning if it contains more than 77 bytes.
The set of strings you specify replaces any existing help text for the column. To
delete help text, specify a null string (“”).
Considerations—HELP TEXT
•
Authorization and access requirements
Only one DDL statement can operate on a given SQL object (or partition of an SQL
object) at a time. An error occurs if you attempt to execute a HELP TEXT statement
while another process is executing a DDL operation on the same object. The specific
error depends on the DDL operation involved and the phase of the operation at
which the conflict occurs. (See DDL (Data Definition Language) Statements
on
page D-19 for more information.)
Examples—HELP TEXT
•
The following example adds help text for the EMPNAME column of the EMP table:
HELP TEXT FOR COLUMN EMPNAME ON EMP IS
"NAME OF EMPLOYEE",
"THE FORMAT IS LAST-NAME, FIRST-NAME, MI";
HISTORY Command
HISTORY is an SQLCI command that displays the commands or statements most
recently entered during the SQLCI session. HISTORY identifies each command by a
number that you can use with the FC command to reexecute or edit the command.
(HISTORY is similar to the TACL command HISTORY.)
The default is 10.
number
is the number of commands to display.
The history buffer contains at most 25 commands. You can use the FC command to
edit and reexecute a command in the history buffer or use the exclamation point
command (!) to reexecute a command without modifying it.
HISTORY [ number ] ;