Developing Portable Applications : 2. Achieving Transparency and Portability : OpenSQL Extensions
 
Share this page                  
OpenSQL Extensions
The gateway allows you to use certain statements that are specific to the host DBMS and are not part of OpenSQL. You can use these host DBMS statements when they are combined with the DIRECT EXECUTE IMMEDIATE statement, which is an extension to OpenSQL. The statements can be embedded in your OpenSQL applications or issued from an Ingres user interface.
The DIRECT EXECUTE IMMEDIATE statement allows you to issue many host DBMS commands that Ingres tools and preprocessors do not understand and OpenSQL does not support. However, you cannot receive data in response to a DIRECT EXECUTE IMMEDIATE statement. Although the gateway does not modify these statements, statements are checked to ensure that they are supported. They are then passed directly to the host DBMS for execution.
See the Ingres OpenSQL Reference Guide for additional information about the DIRECT EXECUTE IMMEDIATE statement.