Neoview SQL Reference Manual (R2.2)

• 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

• OCTET_LENGTH

• POSITION

• SUBSTRING

• SUM

• TRIM

• UPPER

All other functions are Neoview SQL extensions.

38 Introduction