EXECUTE

Execute ::= EXECUTE name [ ( parameter [, ...] ) ];

--创建表reason。
MogDB=# CREATE TABLE reason (
    CD_DEMO_SK          INTEGER          NOT NULL,
    CD_GENDER           character(16)            ,
    CD_MARITAL_STATUS   character(100)
)
;

--插入数据。
MogDB=# INSERT INTO reason VALUES(51, 'AAAAAAAADDAAAAAA', 'reason 51');

--创建表reason_t1。
MogDB=# CREATE TABLE reason_t1 AS TABLE reason;

--为一个INSERT语句创建一个预备语句然后执行它。
MogDB=# PREPARE insert_reason(integer,character(16),character(100)) AS INSERT INTO reason_t1 VALUES($1,$2,$3);

MogDB=# EXECUTE insert_reason(52, 'AAAAAAAADDAAAAAA', 'reason 52');

--删除表reason和reason_t1。
MogDB=# DROP TABLE reason;
MogDB=# DROP TABLE reason_t1;