NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
S-72
Statements
°
DAYOFWEEK
°
EXTEND
°
JULIANTIMESTAMP
°
SETSCALE
°
UPSHIFT
•
Predicates can have multiple values (for example, a, b < 10, 20)
•
SHARE and EXCLUSIVE lock modes let you share or restrict access to locked
data.
•
Objects referred to in SQL statements can be reassigned to different objects at run
time by using DEFINEs.
•
The WHENEVER directive includes an SQLWARNING option and allows a CALL
statement.
Statements
NonStop SQL/MP statements define SQL objects and catalogs, manipulate data within
those objects and catalogs, and control various aspects of the processes that perform the
data definition and manipulation you specify in the statements.
A single NonStop SQL/MP statement can contain up to 32,767 single-byte characters,
including spaces. A tab is considered the same as a space in NonStop SQL/MP
statements.
You can enter and execute most NonStop SQL/MP statements either from SQLCI or
from an embedded SQL program. (SQLCI commands, in contrast to NonStop SQL/MP
statements, can be entered only from SQLCI.)
Each SQL statement must end with a terminator that is not shown in the statement
description because it depends upon the host language. The terminator for SQL
statements in SQLCI, C, Pascal, and TAL is a semicolon (;). The terminator in
COBOL85 is END EXEC.
See SQLCI
on page S-61 and SQLCI Commands on page S-64 for more information
about entering SQL statements in SQLCI. See Embedded SQL on page E-1 for general
information about embedded SQL programs or, for more detailed information, the
NonStop SQL/MP programming manual for a specific language.
The following table summarizes the NonStop SQL/MP statements and directives. (A
directive is a statement that gives instructions to a compiler.) Statements that can be
used only in programs are indicated with an asterisk (*) following the statement name.
For more information about a specific statement listed in the summary, see the separate
entry for that statement.