triggers

[John Carr <74711.77@xxxxxxxxxxxxxx>]

Date:   1/23/98  2:03 PM

RE:     triggers

Dave dave dave.

The Trigger is considered 'Part of' the PF something like a LF is.  
Could you 'Recompile' a LF if someone had it open???  Of course not. 
The File/Trigger were in use (like the above LF example) hence you couldn't
recompile(replace the object) it.  

Also remember you can't ADDPFTRG/RMVPFTRG unless you have an exclusive lock
on the PF. 

Well isn't this something like a mythical RPLPFTRG(replace Trigger)???
You need an exclusive lock on file/trigger(Kinda).
Makes sense to me.

John Carr
EdgeTech


I hope someone could please explain this to me:
        I have a trigger program attached to a PF, defined as *AFTER, *INSERT.
        While I am using a DFU (actually UPDDTA) to roll through a logical view
        of the file, I am signed on in another session.
        In the 2nd session, I try to recompile the trigger program.
        The compile fails, errors found in the binding step.
        The job log says that the binding step failed because
        "Existing object PGM_NAME is in use by another job".
        Now, since I wasn't entering any recs with my DFU, why          
        would the trigger program be locked? (it should only get called AFTER a
rec is ADDED!)
        When I got out of the DFU, the compile would work.
        
Thanks
Dave
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---