Pinned topic SQL triggers and iSeries command RNMLIB
krmilligan 120000MDWP450 Posts
Re: SQL triggers and iSeries command RNMLIB2013-04-16T23:52:34ZThis is the accepted answer. This is the accepted answer.
Figured out that there was a defect preventing the CREATE OR REPLACE TRIGGER option for cleaning up the program left over by the Rename command.
SQL Standard requires an SQL Trigger to have all object references explicitly qualified at the time that the SQL Trigger is created. Thus, you normally need to recreate the SQL Trigger for it to work properly in a new schema or library.