B. SQL Statement Summary : SQL Statements Not Supported by Ingres Star
 
Share this page                  
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
Set statements not listed under Set (see page Set).
The indexes, integrities, and permits of each underlying local DBMS are enforced by the respective local DBMS.