5. Using a Distributed Database : Connecting Directly to a Local Database : Direct Execute Immediate Statement : Direct Execute Immediate Statement Process
Share this page                  
Direct Execute Immediate Statement Process
When the direct execute immediate statement is presented to Ingres Star, it strips off the direct keyword, the with clauses, and the quotes around the string_constant and sends the following statement to the local DBMS:
execute immediate string_constant
The local DBMS, possibly an Enterprise Access, strips off the execute immediate and then parses the query represented by string_constant.
If the query is a legal query for the execute immediate statement, it is executed. If the query is illegal, an error is returned.