Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Jean Sagi — — source: Usenet: comp.databases.informix
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.