I get the following error when the update gets executed on this trigger:
SQLSTATE 56098: An error occurred during implicit rebind or prepare.
CREATE TRIGGER InsertFe_Tgr
AFTER INSERT ON DeliveryJob
REFERENCING NEW AS DJ_New
FOR EACH ROW MODE DB2SQL
IF SUBSTR(DJ_New.CCN,1,4) = '80' THEN
IF (SELECT 1 FROM CargoFolder CF WHERE CF.CCN = DJ_New.CCN AND CF.BKAG_OrgId = '12000.1' AND CF.CAReference3 != 'L' AND CF.Port != '07') IS NOT NULL THEN
UPDATE DeliveryJob DJ SET DJ.DeliveryStatus = 26 WHERE DJ.Id = DJ_New.Id;--
I looked into the error and it said to rebind the package using the rebind command. Not too sure how to get the package name for the rebind command. Can some shed abit more light on this for me, thanks.