SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
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).
Example—UNDERLINE_CHAR
This 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. For more information, see TMF Transactions
on page T-6.)
name
is the name of a table or view to unlock.
Considerations—UNLOCK TABLE

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.

Always follow an UNLOCK TABLE statement with a CONTROL TABLE statement
with the TABLELOCK ENABLE option, as shown in the examples. The CONTROL
TABLE statement provides information at compile time, unlike the UNLOCK TABLE
statement, which is in effect only at execution time.
UNDERLINE_CHAR "character"
UNLOCK TABLE { name }