Direct Connect and Direct Execute Immediate Compared
Although the direct connect and direct execute immediate statements both access local DBMSs, they operate in different ways.
The direct connect statement:
• Is an Ingres Star statement only
• Can execute queries that return rows (for example, any select query)
• Cannot be issued inside an Ingres Star-level transaction. You must first commit the transaction
• Can execute transaction statements, commit, rollback, abort
The direct execute statement:
• Is an Ingres Star and Enterprise Access statement. It is used by Enterprise Access products to allow direct access to the underlying DBMS.
• Cannot run queries that return rows. It cannot run a select query.
• Can be run inside an Ingres Star-level transaction
• Cannot execute transaction statements, commit, rollback, abort.