Direct Disconnect Syntax
The direct disconnect statement has the following format:
direct disconnect
Example: Direct Connect and Direct Disconnect
To place an integrity on an Ingres Star-level table, use the direct connect statement to define the integrity at the local level since an Ingres Star-level table actually resides in a local database.
create table employee (name char(100),
dept integer, salary money)
with node=remote1, database=mydb;
commit;
direct connect with node=remote1,
database=mydb;
create integrity on employee is salary>0;
direct disconnect;