SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Introduction
HP NonStop SQL/MX Reference Manual—523725-004
1-33
ANSI-Compliant Functions
•
DECLARE SCHEMA statement
•
DROP CATALOG statement
•
DROP INDEX statement
•
DROP SQL statement
•
DROP SQLMP ALIAS statement
•
IF statement
•
GRANT EXECUTE statement
•
INITIALIZE SQL statement
•
INVOKE directive
•
LOCK TABLE statement
•
MODULE directive
•
REGISTER CATALOG command
•
REVOKE EXECUTE 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
•
EXTRACT
•
LOWER
•
MAX
•
MIN
•
OCTET_LENGTH
•
POSITION
•
SESSION_USER
•
SUBSTRING
•
SUM