5. Using a Distributed Database : Connecting Directly to a Local Database : Direct Disconnect Statement : Direct Disconnect Syntax
Share this page                  
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;
direct connect with node=remote1,
create integrity on employee is salary>0;
direct disconnect;