Triggers and CRTDUPOBJ -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

Rob,

I think it's because when duplicating the file, the File's Trigger program is expected to be in the *TOLIB, which in your case is QTEMP, so it's probably not there. See below from DB2 UDB for iSeries Database Programming V5R1.

Mike

Create Duplicate Object (CRTDUPOBJ) · When a physical file and its trigger program are originally in the same library, the trigger program library will always be changed to the new library, even if the trigger program doesn't exist in the new library. In addition, the following holds true:

o If the CRTDUPOBJ command is duplicating both the physical file and its trigger program to a new library, then the new trigger program will be associated with the new physical file.

o If the CRTDUPOBJ command is duplicating only the physical file, then the trigger program with the same program name in the TO library will be associated with the new physical file. This is true even if there is no trigger program by that name in the TO library. The library of the trigger program will be changed.

o If the CRTDUPOBJ command is duplicating only the trigger program, then the new trigger program will not be associated with any physical files.

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.