About Encrypted Data In DB2 UDB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Suresh - 26 Apr 2006 13:51 GMT

Hi All

I have one column which has data type of varchar only. in this column
i want to store some secured data (I want to store this data by
encrpting using db2 encryption function).But along with this encrypted
data this column contains normal data also..

But in DB2 while storing encrypted data column should be defined FOR
BIT DATA.
In my case how should I go as my column contains both encrypted and
normal data in same column.

Thanks
Suresh

Reply to this Message

Serge Rielau - 26 Apr 2006 14:02 GMT

> Hi All
>
[quoted text clipped - 7 lines]
> In my case how should I go as my column contains both encrypted and
> normal data in same column.

Split your column. The fact that some part of your column has different
requirements is an indicator that you should have different columns to
begin with.

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message

Suresh - 26 Apr 2006 14:26 GMT

is there any way other than spliting column bcoz i am storing history
data in old value, new value pair in this table and i can not split the
columns.

Reply to this Message

tuarek - 26 Apr 2006 18:03 GMT

Suresh,

Would it be ok for your data security policy, if you use encrypt scalar
function for your secured data? Use encrypt scalar function when
inserting your data.

insert into mytable values encrypt(...)

Regards,

Mehmet

Reply to this Message

Suresh - 27 Apr 2006 06:07 GMT

While using scalar function of encryption on secured data , column data
type should be for bit data, otherwise i cannot use decrypt scalar
function to retrive data. But because of my design limitation i can not
place datatype as for bit data so any other way?

Reply to this Message

Serge Rielau - 27 Apr 2006 11:23 GMT

> While using scalar function of encryption on secured data , column data
> type should be for bit data, otherwise i cannot use decrypt scalar
> function to retrive data. But because of my design limitation i can not
> place datatype as for bit data so any other way?

Suresh you can cast yoru string from and to for bit data.
CAST (c1 AS VARCHAR(10) FOR BIT DATA)
CAST (c1bit AS VARCHAR(10) FOR SBCS DATA)
Since this cast does nothing more that strip the codepage and place it
back it's non invasive.

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message

Suresh - 27 Apr 2006 15:58 GMT

Thanks it worked for me......

Reply to this Message

Mehmet Baserdem - 27 Apr 2006 16:57 GMT

Suresh,

Can you post your encrypt and decrypt statements' final version ? Just
column phrases would be enough.

thanks

Mehmet

Reply to this Message

Suresh - 02 May 2006 07:02 GMT

Here i am forwarding u exapmle with column name XYZ of Varchar type
DECRYPT_CHAR(CAST(XYZ AS VARCHAR(200) FOR BIT DATA))

Reply to this Message