Re: SQL Encryption with Instead of Triggers

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Consider upgrading to 7.1 or higher in order to make use of the FIELDPROC
http://www.mcpressonline.com/database/db2/enable-transparent-encryption-with-db2-field-procedures.html

Charles

On Wed, May 20, 2015 at 4:09 PM, Darlene Wright <
Darlene.Wright@xxxxxxxxxxxxxxx> wrote:

> To Whom it may concern;
> We have been tasked to encrypt several fields in a data file the AS400.
> I have been researching on the best approach with the least impact,  which
> has brought my attention to SQL encryption using Instead of Triggers.
> Does anyone have any insight with this method?   It seems somewhat
> straight forward using insert, delete and update.  Do I need to use API's
> in order to read this data?  Is there a  "Read' trigger? What type of
> Master key.  The data file remains static once we have it on our disk,
> just need to retrieve it upon request.
> Any insight on encrypting data fields in a file on the IBM AS400 would be
> much appreciated.  We are currently at 6.1.
> Thank You
> Darlene
> Darlene Wright
> Programmer/Supervisor
> CrossCheck, Inc.
> 707.665.2100
> 707.793.5799 Fax
> darlenew@xxxxxxxxxxxxxxx<mailto:darlenew@xxxxxxxxxxxxxxx>
> www.cross-check.com<http://www.cross-check.com>
>
> Notice of Confidentiality: This e-mail, and any attachments thereto, is
> intended only for use by the addressee(s) named herein and may contain
> legally privileged and/or confidential information. If you are not the
> intended recipient of this e-mail, you are hereby notified that any
> dissemination, distribution or copying of this e-mail, and any attachments
> thereto, is strictly prohibited. If you have received this e-mail in error,
> please immediately notify me by e-mail (by replying to this message) or
> telephone (noted above) and permanently delete the original and any copy of
> any e-mail and any printout thereof. Thank you for your cooperation with
> respect to this matter.
>
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.