Re: SQL Encrypt Function in a Trigger

[Charles Wilt <charles.wilt@xxxxxxxxx>]

On Tue, Mar 17, 2009 at 7:00 PM, Eftimios Pantzopoulos
<Mike.Pantzopoulos@xxxxxxxxxx> wrote:
> *       Create a before trigger to encrypt the data before insert (I'm not an SQL/PL expert. I copied and hacked this code:
>
> create trigger insert_mxp02
> before insert on mxp02
> referencing new row as n
>
> for each row
> begin
> set n.fld01= encrypt_rc2(n.fld01,'eftimios');
> end

Also I think it should be:
  FOR EACH ROW MODE DB2ROW

Lastly, use DSPFD to make sure that ALWREPCHG(*YES) is set and CHGPF
to change it if not.

HTH,
Charles