Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2012
    Posts
    3

    Unanswered: data mask for integer type in DB2

    Hi, I am trying to mask values in sensitive columns in DB2. Would like to know the function in DB2 (ver 8) which can be used to mask integer type values in SQL. The function will be used in SQL to unload data in sysrec and the same will be used to load in a different environment. Kindly suggest a solution.

    Thanks,
    Balaji N Krishna

  2. #2
    Join Date
    Jun 2007
    Location
    germany
    Posts
    155
    when you say 'mask',
    do you mean 'change to another value'
    or replace with asterisks (*) or some other char?

    as long as these 'sensitive columns' are not parts of keys (or parent/child relationships - foreign keys),
    you change them to what ever you want.
    you may want to use the translate function.

    you would only have to apply during the unload. once unloaded (and 'masked')
    the data would then be loaded 'as is'.
    Dick Brenholtz, Ami in Deutschland

  3. #3
    Join Date
    Jun 2007
    Location
    germany
    Posts
    155
    sorry, translate would not be a good solution.
    how about RANDOM?

    again, if any of these integer columns are used as part of any type of key,
    you will have to employ another method.

    most of the time, sensitive data is char,
    integers representing bank account numbers can be replaced by random,
    since you do not want to use an algorithm.
    Dick Brenholtz, Ami in Deutschland

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •