RE: CRTDUPOBJ of file with trigger renders trigger inoperative

I open a PMR about this issue.  Here's the last reply I got from IBM.

The develop said the issue is that you are mixing SQL tables and        
triggers with non-SQL CRTDUPOBJ.  He said you should just modify the SQL
statements to create them to the new library.  It will not work if you  
mix them as you were.                                                   
                                                                        
Thanks for using the IBM Rochester Support Center!!                     


I'm not real happy with that answer, how about you all?


Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx 
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Wilt, Charles
> Sent: Monday, December 12, 2005 7:55 AM
> To: midrange-l@xxxxxxxxxxxx
> Subject: CRTDUPOBJ of file with trigger renders trigger inoperative
> 
> I'm trying to use CRTDUPOBJ to create a duplicate of a file into a new
> library.
> 
> The file has a trigger attached and I actually do want the 
> trigger to be
> on the duplicate file.
> 
> The problem is that while it seems that DB2 creates a 
> duplicate trigger
> in the new library and associates the duplicate trigger with the
> duplicate file, the trigger's status is *INOPERATIVE.
> 
> >From what I could find online, in the infocenter and via google,
> duplicating the file and attached trigger should work.
> 
> Why doesn't it?
> 
> I couple of things I found lead to be think that perhaps it 
> was because
> the trigger references two files that weren't in the new library.
> However, the trigger's status is still *INOPERATIVE even after
> duplicating those two referenced files prior to duplicating the file
> with the trigger.
> 
> Anybody know what is going on?
> 
> This is on v5r3.
> 
> Thanks,
> 
> Charles Wilt
> --
> iSeries Systems Administrator / Developer
> Mitsubishi Electric Automotive America
> ph: 513-573-4343
> fax: 513-398-1121
>  
> 
> -- 
> 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.
> 
>