Re: Re: encrypt/decrypt data before an update/insert

The soon to be released IDS 9.5/10 is suposed to do this for you. J. -----Original Message----- From: "Ben" <ben_informix@comcast.net> To: <informix-list@iiug.org> Date: Tue, 15 Feb 2005 14:49:34 -0500 Subject: Re: encrypt/decrypt data before an update/insert I am not aware of any 'built-in' functions - you may want to look into user defined routines (UDR) - you can write your own 'c' code and call that routine as an external procedure..... ----- Original Message ----- From: "Brett Sinclair" <lbrettsinclair@yahoo.com> To: <informix-list@iiug.org> Sent: Tuesday, February 15, 2005 11:18 AM Subject: encrypt/decrypt data before an update/insert > Hello everybody > I'm looking for a way to create a stored procedure that will encrypt > data in a column when doing an update or an insert. > I would need also the decrypt version when doing a select of that > column. > I think I would put that call in a trigger so it would be transparent > to the user. > > Anybody has this type of stored procedure ? > > Regards > Brett > sending to informix-list Jean Sagi jeansagi@myrealbox.com jeansagi@yahoo.com sending to informix-list