CREATE GLOBAL MAPPING VOVA_MAP_RULE
USING PLUGIN WIN_SSPI
FROM USER "Domain\Vova"
TO USER VOVA;

execute block
AS
declare variable s varchar(300);
begin
  S = 'EXECUTE PROCEDURE sp_write_chg_offtime :p01;';
  execute statement (:S)
  ( p01 := 1 )
  on external data source 'DBLOG';
end

execute block
returns (  p01 bigint )
AS
declare variable s varchar(2000);
begin
  S = 'select first 1  chg_conn_id from chg_conn';
  execute statement (:S)
  on external data source 'DBLOG'
  into :p01;
  suspend;
end

execute block
returns (  p01 bigint )
AS
declare variable s varchar(2000);
begin
  S = 'select first 1  chg_conn_id from chg_conn';
  execute statement (:S)
--  as user 'SYSDBA'
--  password 'masterkey'
  on external data source 'LOCALHOST/3052:DBLOG'
  into :p01;
  suspend;
end