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
• Select statement clauses:
FIRST n
AFTER n
TOP n
LIMIT n
OFFSET n
FETCH FIRST n or FETCH NEXT n
• Synonyms:
create synonym
drop synonym
• Set statements not listed under
Set.
The indexes, integrities, and permits of each underlying local DBMS are enforced by the respective local DBMS.
Last modified date: 08/14/2024