Neoview SQL Reference Manual (R2.3)

• DROP VIEW statement

• GRANT statement

• GRANT EXECUTE statement

• GRANT SCHEMA statement

• INSERT statement

• PREPARE statement

• REVOKE statement

• REVOKE EXECUTE statement

• REVOKE SCHEMA 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 INDEX statement

• ALTER TRIGGER statement

• BEGIN WORK statement

• CREATE INDEX statement

• DROP INDEX statement

• LOCK TABLE statement

• SAMPLE clause

• SEQUENCE BY clause

• SET TABLE TIMEOUT statement

• TRANSPOSE clause

• 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

• CURRENT_TIMESTAMP

• EXTRACT

• LOWER

• MAX

• MIN

• NULLIF

38 Introduction