Rebind error on update

ApoPen · #1 (**permalink**) 09-21-05, 11:22

I get the following error when the update gets executed on this trigger:

SQLSTATE 56098: An error occurred during implicit rebind or prepare.

Code:

CREATE TRIGGER InsertFe_Tgr
AFTER INSERT ON DeliveryJob
REFERENCING NEW AS DJ_New
FOR EACH ROW MODE DB2SQL
BEGIN ATOMIC
    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;--
        END IF;--
    END IF;--
END;

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.

Internet Services

Web Development

Digital Marketing

Consumer Tech