Neoview SQL Reference Manual (R2.3)

syntax diagram of, 319
COSH function
examples of, 320
syntax diagram of, 320
COUNT function
DISTINCT clause within, 321
examples of, 321
syntax diagram of, 321
COUNT window function
examples of, 449
syntax diagram of, 448
CREATE INDEX statement
authorization and availability requirements , 59
examples of, 59
limits on indexes, 59, 463
syntax diagram of, 58
CREATE MATERIALIZED VIEW statement
considerations for, 62
example of, 64
syntax diagram of, 60
CREATE MVGROUP statement
authorization and availability requirements, 66
example of, 66
CREATE MVGROUP statement, syntax description of,
66
CREATE SCHEMA statement
considerations for, 67
examples of, 67
syntax diagram of, 67
CREATE SET TABLE
example, 74
restrictions, 74
syntax, 70
CREATE SET TABLE statement, 70
example of, 80
CREATE SYNONYM statement, 68
considerations of, 68
example of, 68
syntax diagram of, 68
CREATE TABLE
Neoview SQL extensions, 78
CREATE TABLE AS statement
considerations for, 74
syntax diagram of, 69
CREATE TABLE LIKE statement
considerations for, 74
syntax diagram of, 69
CREATE TABLE statement
considerations for, 74
DEFAULT clause, 268
examples of, 78, 80
syntax diagram of, 69
CREATE TRIGGER
considerations for, 83
CREATE TRIGGER statement
authorization and availability requirements, 83
CREATE VIEW statement
authorization and availability requirements, 89
examples of, 90
syntax diagram of, 88
updatability requirements, 90
WITH CHECK OPTION within, 89
CREATE VOLATILE INDEX statement
syntax diagram of, 58
CREATE VOLATILE TABLE statement
considerations for, 74
examples of, 79
syntax diagram of, 69
cross join, definition of, 64
CROSS join, description of, 150
CURRENT_DATE function
examples of, 324
syntax diagram of, 324
CURRENT_ROLE function
example of, 325
syntax diagram of, 325
CURRENT_TIME function
examples of, 326
precision specification within, 326
syntax diagram of, 326
CURRENT_TIMESTAMP function
examples of, 323, 327
precision specification within, 323, 327
syntax diagram of, 323, 327
CURRENT_USER function
syntax diagram of, 328
D
Data Definition Language (DDL) statements
summary of, 41
ALTER MATERIALIZED VIEW, 44
ALTER TABLE, 47
ALTER VIEW, 51
BEGIN WORK, 52
COMMIT WORK, 56
CREATE MATERIALIZED VIEW, 60
CREATE TABLE, 69
CREATE VIEW, 88
DROP INDEX, 95
DROP MATERIALIZED VIEW, 96
DROP TABLE, 100
DROP VIEW, 102
GRANT, 118
GRANT EXECUTE, 120
GRANT SCHEMA, 122
LOCK TABLE, 130
MERGE INTO, 132
PREPARE, 135
REVOKE, 137
REVOKE EXECUTE, 139
REVOKE SCHEMA, 141
ROLLBACK WORK, 143
SET SCHEMA, 166
SET TABLE TIMEOUT, 168
SET TRANSACTION, 170
UPDATE STATISTICS, 185
Data Manipulation Language (DML) statements
summary of, 42
473