The PROCESS SQL statement is used to issue SQL statements to the underlying database. The statements are specified in a statement-string, which can also include constants and parameters.
The set of statements which can be issued is also referred to as Flexible SQL and comprises those statements which can be issued with the SQL statement EXECUTE.
In addition, Flexible SQL includes the following DB2-specific statements:
CALL
CONNECT
GET DIAGNOSTICS
SET APPLICATION ENCODING SCHEME
SET CONNECTION
SET CURRENT DEGREE
SET CURRENT LC_CTYPE
SET CURRENT OPTIMIZATION HINT
SET CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION
SET CURRENT PACKAGE PATH
SET CURRENT PACKAGESET
SET CURRENT PATH
SET CURRENT PRECISION
SET CURRENT REFRESH AGE
SET CURRENT RULES
SET CURRENT SCHEMA
SET CURRENT SQLID
SET ENCRYPTION PASSWORD
SET
host-variable=special-register
RELEASE
Note:
SQL statements issued by PROCESS SQL are skipped during static
generation. Thus they are always executed dynamically via NDBIOMO.
To avoid transaction synchronization problems between the Natural environment and DB2, the COMMIT and ROLLBACK statements must not be used within PROCESS SQL.
Futher details and syntax: PROCESS SQL in Natural SQL Statements in the Natural Statements documentation.
