CREATE TRIGGER ON_INSERT_LOGTABLE FOR LOGTABLE
AS
DECLARE sqlstr VARCHAR(128);
DECLARE rmtdb VARCHAR(128) = 'HOST_B:MY_DB.fdb';
DECLARE usernm VARCHAR(32) = 'sysdba';
DECLARE passwd VARCHAR(32)  = 'masterkey';
BEGIN
sqlstr = 'INSERT INTO LOGTABLE VALUES(?)';
EXECUTE STATEMENT (:sqlstr) (new.DATA)
ON EXTERNAL DATA SOURCE :rmtdb
AS USER :usernm PASSWORD :passwd;
END

set term ^^;
create procedure WV_TAB_A
(
rangeMin integer,
rangeMax integer
)
returns
(
UNIQID integer,
HOSTNM varchar(64)
)
AS
BEGIN
FOR SELECT UNIQID,HOSTNM FROM TAB_A WHERE UNIQID BETWEEN :rangeMin AND :rangeMax
INTO :UNIQID, :HOSTNM
DO SUSPEND;
END
^^
set term ;^^

set term ^^;
create procedure WV_TAB_A (
rangeMin integer, rangeMax integer
) returns (
UNIQID integer,
HOSTNM varchar(64)
) AS
BEGIN
FOR SELECT UNIQID,HOSTNM FROM TAB_A WHERE UNIQID BETWEEN :rangeMin AND :rangeMax
INTO :UNIQID, :HOSTNM
DO SUSPEND;
END
^^
set term ;^^

CREATE TRIGGER MY_TEST_TRIGGER FOR TEST_TABLE
BEFORE INSERT OR UPDATE
AS
BEGIN
new.RecordTimestamp = current_timestamp;
END

CREATE TRIGGER "MY_TEST_TRIGGER" FOR "TEST_TABLE"
ACTIVE POSITION 0
AS
BEGIN
new.RecordTimestamp = current_timestamp;
END

CREATE TABLE TAB_A
(
ID VARCHAR(10) NOT NULL PRIMARY KEY
)

SET GENERATOR GEN_AUTO_ID TO 1000000000

SELECT * FROM TAB_A ORDER BY CAST(ID AS NUMERIC(10))

SELECT * FROM PARAM_VIEW(パラメータ)

CREATE PROCEDURE プロシージャ名 (パラメータリスト)
RETURNS (戻り値リスト)
AS
[ ローカル変数定義 ]
BEGIN
[ 処理ステートメント ]
END

仮引数名 型名 [, ...]

FOR SELECT * FROM テーブル WHERE 条件指定
INTO :戻り値変数 [, ...]
DO SUSPEND;