SQL/MX 2.x Reference Manual (H06.04+)
Introduction
HP NonStop SQL/MX Reference Manual—540440-003
1-33
Statements That Are SQL/MX Extensions
•
DROP PROCEDURE statement
•
DROP SCHEMA statement
•
DROP TABLE statement
•
DROP TRIGGER statement
•
DROP VIEW statement
•
END DECLARE SECTION declaration
•
EXEC SQL directive
•
EXECUTE statement
•
EXECUTE IMMEDIATE statement
•
FETCH statement
•
GET DESCRIPTOR statement
•
GET DIAGNOSTICS statement
•
GRANT statement
•
INSERT statement
•
OPEN statement
•
PREPARE statement
•
REVOKE statement
•
ROLLBACK WORK statement
•
SELECT statement
•
SET statement
•
SET CATALOG statement
•
SET DESCRIPTOR statement
•
SET SCHEMA statement
•
SET TRANSACTION statement
•
TABLE statement
•
UPDATE statement
•
VALUES statement
•
WHENEVER declaration
Statements That Are SQL/MX Extensions
These statements are SQL/MX extensions to the ANSI standard. This list does not
include MXCI commands, all of which are SQL/MX extensions.
•
ALTER INDEX statement
•
ALTER SQLMP ALIAS statement
•
ALTER TRIGGER
•
BEGIN WORK statement
•
Compound (BEGIN...END) statement
•
CONTROL QUERY DEFAULT statement
•
CONTROL QUERY SHAPE statement
•
CONTROL TABLE statement
•
CREATE CATALOG statement
•
CREATE INDEX statement
•
CREATE SQLMP ALIAS statement
•
DECLARE CATALOG statement
•
DECLARE MPLOC statement
•
DECLARE NAMETYPE statement