MX Release 3.1 (H06.23+, J06.12+)

ManualsBrandsHP ManualsServerHP Integrity NonStop H-Series

111

112

113

114

115

116

117

118

119

120

DescriptionSQL Statement

Loads a specified index with data from a specified table.POPULATE INDEX

Compiles an SQL statement for later use with the EXECUTE statement.PREPARE

Deletes all data from a table and its related indexes.PURGEDATA

Revokes access privileges for a table or view from specified users.REVOKE

Revokes privileges for executing a stored procedure from specified

roles.

REVOKE EXECUTE

Undoes all modifications to database objects during the current

transaction, releases all locks on database objects held by the

transaction, and ends the transaction.

ROLLBACK WORK

Retrieves data from tables, views, derived tables determined by the

evaluation of query expressions, or joined tables.

SELECT

Retrieves the count of rows from an SQL/MX table.SELECT ROW COUNT

Sets the default logical catalog for unqualified schema names for the

current SQL session.

SET CATALOG

Sets the default NonStop operating system volume, and subvolume for

physical object names for the current SQL session.

SET MPLOC

Sets the NAMETYPE attribute value for the current SQL session.SET NAMETYPE

Sets the schema name for unqualified object names for the current

session.

SET SCHEMA

Sets a dynamic timeout value for a lock timeout or a stream timeout in

the environment of the current session.

SET TABLE TIMEOUT

Sets attributes, such as isolation level and access mode, for the next

transaction.

SET TRANSACTION

Displays the access plan, controls, and system defaults in effect for the

current SQL session.

SHOWCONTROL

Displays the DDL syntax used to create a table, view, or stored

procedure as it exists in metadata, including the dependent objects.

SHOWDDL

Releases locks owned by MXCI on a nonaudited SQL/MP table or on

underlying nonaudited SQL/MP tables of a view.

UNLOCK TABLE

Updates data in a row or rows of a table or view that can be updated.UPDATE

Updates histogram statistics for one or more groups of columns in a

table.

UPDATE STATISTICS

120 Supported SQL statements