SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Introduction
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
1-35
ANSI-Compliant Functions
•
DECLARE SCHEMA statement
•
DROP CATALOG statement
•
DROP INDEX statement
•
DROP SQL statement
•
DROP SQLMP ALIAS statement
•
IF statement
•
GET ALL SECURITY_ADMINS statement
•
GIVE CATALOG statement
•
GIVE Object statement
•
GRANT CREATE CATALOG statement
•
GRANT CREATE SCHEMA statement
•
GRANT EXECUTE statement
•
GRANT SECURITY_ADMIN statement
•
INITIALIZE SQL statement
•
INVOKE directive
•
LOCK TABLE statement
•
MODULE directive
•
REGISTER CATALOG command
•
REVOKE CREATE CATALOG statement
•
REVOKE CREATE SCHEMA statement
•
REVOKE EXECUTE statement
•
REVOKE SECURITY_ADMIN statement
•
SAMPLE clause
•
SEQUENCE BY clause
•
SET (assignment) statement
•
SET MPLOC statement
•
SET NAMETYPE statement
•
SET TABLE TIMEOUT statement
•
SIGNAL SQLSTATE statement
•
TRANSPOSE clause
•
UNLOCK TABLE statement
•
UNREGISTER CATALOG command
•
UPDATE STATISTICS statement
ANSI-Compliant Functions
These functions are ANSI compliant, but some might contain SQL/MX extensions:
•
AVG function
•
CASE expression
•
CAST expression
•
CHAR_LENGTH
•
COUNT Function
•
CURRENT
•
CURRENT_DATE
•
CURRENT_TIME
•
CURRENT_TIMESTAMP
•
CURRENT_USER