RE: Who envoked that trigger program?

The trigger program may triggered by:

     STRSQL
     STRDFU
     DBU
     EZVIEW
     RPGLE
     SQLRPGLE
     and etc...

All of the examples I have found

Look for a program in the call stack that doesn't start with Q
Look for a program in the call stack that doesn't exist in library that doesn't 
start with a Q
Use a fixed call counter to go back in the call stack

All of the above solutions above won't work if the source of the trigger is 
'unknown'.


Thanks in advance



Andrew Lutz
Database Administrator
(415) 291-6160
alutz@pmigroup.com


>>> sublime78ska@yahoo.com 12/19/01 04:40PM >>>
I asked this two weeks ago and got two good responses.

To see the others, search the archives for 'trigger buffer'.  The date was
12/8/01.

Phil

>
>
> The following program returns the name of a program up in the
> call stack. YOu give as a parameter how up you want to go (1 in
> your case).
>
>              PGM        PARM(&NIVRECA &PGMID)
>
>              DCL        VAR(&NIVRECA) TYPE(*CHAR) LEN(2)
>              DCL        VAR(&NIVREC) TYPE(*DEC) LEN(2 0)
>              DCL        VAR(&NIVTST) TYPE(*DEC) LEN(2 0)
>              DCL        VAR(&NIVTRV) TYPE(*DEC) LEN(2 0)
>              DCL        VAR(&NIVBIN) TYPE(*CHAR) LEN(4)
>              DCL        VAR(&RCVVAR) TYPE(*CHAR) LEN(512)
>              DCL        VAR(&APIERRCDE) TYPE(*CHAR) LEN(8) +
>                           VALUE(X'0000000000000000')
>              DCL        VAR(&MSGKEY) TYPE(*CHAR) LEN(4)
>              DCL        VAR(&PGMID) TYPE(*CHAR) LEN(10)
>              DCL        VAR(&PGMIDPR) TYPE(*CHAR) LEN(10)
>
> /* initialisation                                                    */
>              CHGVAR     VAR(&NIVREC) VALUE(&NIVRECA)
>              CHGVAR     VAR(&NIVTST) VALUE(2)
>              CHGVAR     VAR(&NIVTRV) VALUE(0)
>
>  DOUNTIL:
>              IF         COND(&NIVREC *EQ &NIVTRV) THEN(GOTO +
>                           CMDLBL(FINDO))
>
>              CHGVAR     VAR(%BIN(&NIVBIN)) VALUE(&NIVTST)
>              CALL       PGM(QMHSNDPM) PARM(' ' ' ' 'Dummy' +
>                           X'00000005' '*INFO' '*' &NIVBIN &MSGKEY +
>                           &APIERRCDE)
>              MONMSG     MSGID(CPF0000) EXEC(DO)
> /* on a depasser le "call stack"                                     */
>              CHGVAR     VAR(&PGMID) VALUE(*ERR)
>              GOTO       CMDLBL(FINDO)
>              ENDDO
>              CALL       PGM(QMHRCVPM) PARM(&RCVVAR X'00000200' +
>                           'RCVM0300' '*' &NIVBIN '*ANY' &MSGKEY +
>                           X'00000000' '*REMOVE' &APIERRCDE)
>              CHGVAR     VAR(&PGMID) VALUE(%SST(&RCVVAR 472 10))
> /* on ignore le CLPEP qui existe en mode ILE                         */
>              IF         COND(&PGMID *NE &PGMIDPR) THEN(DO)
>              CHGVAR     VAR(&NIVTRV) VALUE(&NIVTRV + 1)
>              CHGVAR     VAR(&PGMIDPR) VALUE(&PGMID)
>              ENDDO
>              CHGVAR     VAR(&NIVTST) VALUE(&NIVTST + 1)
>              GOTO       CMDLBL(DOUNTIL)
>  FINDO:
>
>              ENDPGM
>
> Denis Robitaille
> Directeur services techniques
> Cascades Inc
> 819 363 5187
> fax 819 363 5177

>


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.