DB2 Primary Keys Masking

sudmm · #1 (**permalink**) 04-20-09, 02:58

Hi,
We need to mask out the data in the primay key columns like 512345 should be masked to 500000 with out losing uniqueness. Can anyone please tell me a viable approach?

Thanks.

nick.ncs · #2 (**permalink**) 04-20-09, 05:15

which db2 version you are using?

sudmm · #3 (**permalink**) 04-20-09, 05:19

We are using DB2 9.0 on AIX

przytula_guy · #4 (**permalink**) 04-20-09, 11:31

the db2 platform/version will not solve the problem
what is the purpose of this and how did you try this ??
be as specific as possible to complete the scenario/messages....

stolze · #5 (**permalink**) 04-20-09, 16:25

I am not sure how this should work. You ignore the last 5 digits (or set them to 0) and still want to get unique values? How would you handle 512345 and 598765?

Getting the result you mentioned can be done by:

Code:

SELECT(  col / 100000 ) * 100000
FROM ...

of course. (That's standard programming technique.)

sudmm · #6 (**permalink**) 04-20-09, 23:32

Yes, I still want to have uniqueness between the rows of a table. Can any one suggest the best alg. for this requirement.

stolze · #7 (**permalink**) 04-21-09, 08:37

Once you answer my question: how will could you guarantee uniqueness, i.e. what should happen with the values, we can tell you how to do that.

sudmm · #8 (**permalink**) 04-21-09, 08:44

Hi Stolze,
I am in need of an alg./ method that will scramble the numbers in a key column with out affecting it's unique property. i.e. even after scrambling, I should able to find that row uniquely using the new scrambled value in that key column.

Could you please suggest me something of this sort?

stolze · #9 (**permalink**) 04-21-09, 14:09

What do you mean with "scramble"?

Internet Services

Web Development

Digital Marketing

Consumer Tech