8. OpenSQL Statements : Direct Execute Immediate : Description
 
Share this page                  
Description
The DIRECT EXECUTE IMMEDIATE statement allows statements to be sent to the Enterprise Access product or DBMS to which a session is connected. The Enterprise Access product does not translate the statement. If the statement is not supported by the DBMS or Enterprise Access product, an error is returned. The DIRECT EXECUTE IMMEDIATE statement cannot be used to return rows to a session.
A host language variable or string literal can be used to specify the statement. If you use a string literal, avoid embedding quotes in the literal. If you specify the statement using a host language variable, the OpenSQL string‑delimiting conventions must be observed.