|
Dan, My understanding has always been that triggers run within the same job that performed the database operation that "triggered the trigger". So it will get all of its job attributes (*LIBL etc.) from that job. So if you are putting a trigger on a file that can be updated via things like ODBC/JDBC where the job is some pre-start job with no special *LIBL then you have to take that into account within your trigger program. Mark To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx> cc: bcc: Subject: JOBD for a trigger proram Dan Rasch <drasch@xxxxxxxxxxxx> Sent by: midrange-l-bounces@xxxxxxxxxxxx 10/02/2003 08:26 PM Please respond to Midrange Systems Technical Discussion <font size=-1></font> We just sent out the first wave of a product enhancement to six of our customers, and spent most of the day debugging a problem. We have a trigger program that is monitoring changes to a certain file, but when the program is called, it is using the system default library list found in the system valu (I think it is QUSRLIBL). One of our programs in the job stream of the trigger program exists outside the library list of QUSRLIBL. We tried changing the JOBD of the dummy user that calls the trigger program, but it ignored that JOBD and used the system default. We looked at the DSPFD for the file and all the trigger information, but never saw a JOBD or library list entry. What determines the JOBD, and how do we change it? Dan Rasch - because if the human species concentrated on the really important things in life, there would be a shortage of fishing poles! IBM Certified twice....... but still a couple PTFs away from Nirvana. _______________________________________________ This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.