Skip to content

Instantly share code, notes, and snippets.

@andersoal
Created July 30, 2019 20:37
Show Gist options
  • Select an option

  • Save andersoal/b6a656378a4afd2775fa58439ddc9820 to your computer and use it in GitHub Desktop.

Select an option

Save andersoal/b6a656378a4afd2775fa58439ddc9820 to your computer and use it in GitHub Desktop.
#Mega Agendas de Integração - TRIGGER definir sempre um usuário fixo que é utilizado na integração dos movimentos - Modelo que permite múltiplas agendas rodando ao mesmo tempo em diferentes servidores#MegaERP
create or replace TRIGGER MGCLI.T_CLI_GLO_AGENDAINTMULTI
BEFORE INSERT OR UPDATE ON MGGLO.GLO_AGENDAINTMULTI
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
BEGIN
:NEW.AIM_IN_USUARIOINTEGRA := 1;
END;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment