Neoview SQL Reference Manual (R2.4)

• GRANT EXECUTE statement

• INSERT statement

• MERGE INTO statement

• PREPARE statement

• REVOKE statement

• REVOKE EXECUTE statement

• ROLLBACK WORK statement

• SELECT statement

• SET SCHEMA statement

• SET TRANSACTION statement

• UPDATE statement

Statements That Are Neoview SQL Extensions

These statements are Neoview SQL extensions to the ANSI standard.

• ALTER MATERIALIZED VIEW statement

• ALTER MVGROUP statement

• ALTER SYNONYM statement

• ALTER TRIGGER statement

• BEGIN WORK statement

• CREATE INDEX statement

• CREATE MATERIALIZED VIEW statement

• CREATE MVGROUP statement

• CREATE SYNONYM statement

• DROP INDEX statement

• DROP MATERIALIZED VIEW statement

• DROP MVGROUP statement

• DROP SYNONYM statement

• EXPLAIN statement

• GET SERVICE statement

• GRANT SCHEMA statement

• LOCK TABLE statement

• REVOKE SCHEMA statement

• SET TABLE TIMEOUT statement

• UNLOCK TABLE statement

• UPDATE STATISTICS statement

ANSI-Compliant Functions

These functions are ANSI compliant, but some might contain Neoview SQL extensions:

• AVG function

• CASE expression

• CAST expression

• CHAR_LENGTH

• COALESCE

• COUNT Function

• CURRENT

• CURRENT_DATE

• CURRENT_TIME

36 Introduction