SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-72
SQL/MP Extensions to SQL 1992

CREATE INDEX

ALTER {TABLE | INDEX | COLLATION | PROGRAM | VIEW}

DROP {INDEX | PROGRAM}

COMMENT ON

HELP TEXT

UPDATE STATISTICS

Additional DCL statements and data control directives:

LOCK TABLE

UNLOCK TABLE

FREE RESOURCES

CONTROL TABLE

CONTROL EXECUTOR

CONTROL QUERY

Additional functions:

CONVERTTIMESTAMP

DATEFORMAT

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.