Re: SQL ENCRYPT_RC2() function Question

What you see, is origin for similar inquiries; i.e. it is somewhat confusing such that others have encountered the same. However it is correct according to the rules, that the SET statement is failing with the SQL0303 condition.

You are trying to encrypt to the target field ACCOUNT, which was previously modified in its attributes, to be binary and the 8-byte aligned longer field length. Trying to ENCRYPT_RC2() on this longer field would require a larger target, according to the rules of the ENCRYPT function(s).

You need to encrypt the inversed type & length value for ACCOUNT. That is, encrypt the value passed by the program to be inserted, not the value in the row [buffer]. Effectively:
SET N . ACCOUNT = ENCRYPT_RC2 ( CHAR( N . ACCOUNT , 17), PASSWD );

It might be clearer, from the following [where the original CCSID for ACCOUNT is assumed to be US English]:

CREATE TRIGGER MWLIBR.TEST_INSERT
BEFORE INSERT ON MWLIBR.TESTP
REFERENCING NEW AS N FOR EACH ROW MODE DB2ROW
BEGIN
DECLARE PASSWD VARCHAR ( 127 ) ;
/* */ DECLARE CHAR_ACCOUNT CHAR(17) CCSID 37;
/* */ SET CHAR_ACCOUNT = N . ACCOUNT ;
SET PASSWD = 'my20charpasswordhere' ;
/*- SET N . ACCOUNT = ENCRYPT_RC2 ( N . ACCOUNT , PASSWD ); -*/
/* */ SET N . ACCOUNT = ENCRYPT_RC2 ( CHAR_ACCOUNT , PASSWD ) ;
END

Regards, Chuck