Example: Direct Execute Immediate
The following example illustrates how you send a create integrity statement to a local DBMS to be executed using direct execute immediate:
create table employee (name char(100),
dept integer, salary money)
with node=remote1, database=mydb;
direct execute immediate ’create integrity
on employee is salary>0’
with node=remote1, database=mydb;