5. Using a Distributed Database : Connecting Directly to a Local Database
 
Share this page                  
Connecting Directly to a Local Database
While using Ingres Star, you can access an Ingres or Enterprise Access local DBMS directly. This is useful in some processing situations, for example, if you want to modify a table’s storage structure, create secondary indexes, or grant other users access to a table.
Once you are in this directly connected or pass-through mode, Ingres Star merely passes through all statements and returns all responses. Statements are sent to the local database, whose server accepts or rejects the statement. When in this pass-through mode, Ingres Star does no syntax checking on the statement.
You can access a local DBMS directly with either of the following statements:
direct connect
direct execute immediate