SQL Statements Not Supported by Ingres Star
Currently, you cannot use the following statements against a distributed database (although most can be executed within a direct connect or a direct execute immediate statement).
The unsupported SQL statements are:
- create|alter|drop location
- declare|alter table
- create|alter|drop user
- Events:
create dbevent
drop dbevent
get dbevent
raise dbevent
register dbevent
remove dbevent
raise error - Groups:
alter group
create group
drop group - comment on
message - create index
- declare global temporary table
- Integrities and permits:
create integrity
drop integrity
drop permit
revoke - grant
- modify
- Procedures:
create procedure
drop procedure - Roles:
alter role
create role
drop role - Rules:
create rule
drop rule - Schema:
create schema
drop synonym - Security alarms/audit:
create security alarm
drop security_alarm
enable security_audit
disable security_audit - Synonyms:
create synonym
drop synonym
The indexes, integrities, and permits of each underlying local DBMS are enforced by the respective local DBMS.
© 2007 Ingres Corporation.
All rights reserved.