NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
U-1
U
UNDERLINE_CHAR Option
UNDERLINE_CHAR is an option of the SQLCI report writer SET STYLE command
that specifies the character to use for underlining.
Underline characters print below headings and above subtotals and totals.
character
is a printable, single-byte character to use for underlining. The default is - (hyphen).
Examples—UNDERLINE_CHAR
•
The following example changes the underline character to the equal sign:
>> SET STYLE UNDERLINE_CHAR "=";
A heading appears as:
ORDERNUM
==========
UNLOCK TABLE Statement
UNLOCK TABLE is a DCL statement that releases locks owned by SQLCI or by a host
program on a nonaudited table or on underlying nonaudited tables of a view.
UNLOCK TABLE does not affect audited tables. (Ending a TMF transaction unlocks an
audited table. See TMF Transactions
on page T-5 for more information.)
name
is the name of a table or view to unlock.
Considerations—UNLOCK TABLE
•
Authorization requirements
To unlock a table, you must have authority to read the table. To unlock a view, you
must have authority to read the tables underlying the view.
•
Performance considerations
UNDERLINE_CHAR "character"
UNLOCK TABLE { name }