Was this helpful?
DIRECT EXECUTE IMMEDIATE
The DIRECT EXECUTE IMMEDIATE statement sends DBMS‑specific commands to the DBMS without translation.
The DIRECT EXECUTE IMMEDIATE statement has the following format:
EXEC SQL DIRECT EXECUTE IMMEDIATE string | string_variable
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.
Last modified date: 11/09/2022