Re: Field level encryption and decryption APIs

["Bob P. Roche" <BRoche@xxxxxxxxxxxxxxxxx>]

So build a set of functions to do that using SQLRPGLE and call them when 
you need to encrypt or decrypt a field. then the current program can stay 
as is. Unless you mean standards prevent the use of SQLRPGLE at all. This 
would also give you an easy of doing this in the future by having it as an 
external function.



Jose Santana <jsantana@xxxxxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
02/07/2007 11:12 AM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
cc

Subject
Re: Field level encryption and decryption APIs






That sounds good except that I need to modify programs that are not 
SQLRPG type and need to stay that way to comply with the application 
standards.

Jose

rob@xxxxxxxxx wrote:

> No, but have you looked at the ENCRYPT and DECRYPT bifs in SQL?
>
> Rob Berendt