Réf. : Trigger program being called recursively

Hi

When your trigger call your program, you cannot update the records. To skip this
problem, your trigger program just have to submit another job to do this update.
So when the submitted job will start, your record will be available. I don't
know if it's the best way to do it, but it's working ;-)

Good luck

Jean-Christophe


07/05/2001 15:51
Internet (Embedded image moved to file: pic12549.pcx)
jfinney@omnia.co.za - 07/05/2001 15:51


Veuillez répondre à RPG400-L@midrange.com

Pour :    RPG400-L

cc :

ccc : Jean-Christophe Fargette


Objet :   Trigger program being called recursively




___________________________________________________________

This message and any attachments (the "message") is intended solely for
the addressees and is confidential.  If you receive this message in error,
please delete it and immediately notify the sender.

Any use not in accord with its purpose, any dissemination or disclosure,
either whole or partial, is prohibited except formal approval.

The internet can not guarantee the integrity of this message.  BNP PARIBAS
(and its subsidiaries) shall (will) not therefore be liable for the message
if modified.
                       --------------------------------------------------
Ce message et toutes les pieces jointes (ci-apres le "message") sont
etablis a l'intention exclusive de ses destinataires et sint confidentiels.
Si vous recevez ce message par erreur, merci de le detruire et d'en avertir
immediatement l'expediteur.

Toute utilisation de ce message non conforme a sa destination, toute
diffusion ou toute publication, totale ou partielle, est interdite, sauf
autorisation expresse.

L'internet ne permettant pas d'assurer l'integrite de ce message, BNP
PARIBAS (et ses filiales) decline(nt) toute responsabilite au titre de ce
message, dans l'hypothese ou il aurait ete modifie.
___________________________________________________________

Hi all,

I've a problem with a trigger program. The trigger is *AFTER/*UPDATE and,
when fired, it needs to update records in the same file. How do I make sure
it does not call itself recursively (as I am currently receiving this error
message).

Parms on ADDPFTRG CL cmd

Physical file

  . . . . . . . . . > EWR
  Library  . . . . . . . . . . .     *LIBL
Trigger time . . . . . . . . . . > *AFTER
Trigger event  . . . . . . . . . > *UPDATE
Program  . . . . . . . . . . . . > T_EWRR01
  Library  . . . . . . . . . . .     *LIBL
Replace trigger  . . . . . . . . > *YES
Allow Repeated Change  . . . . . > *YES
Threadsafe . . . . . . . . . . .   *UNKNOW
Multithreaded job action . . . .   *SYSVAL
Trigger update condition . . . . > *CHANGE

Regards
John.

pic12549.pcx