Scrambling rules

FM/Db2 scrambles data according to these rules:

• If you do not specify any value or range options:
  • Uppercase alphabetic characters are scrambled to other uppercase alphabetic characters.
  • Lowercase alphabetic characters are scrambled to other lowercase alphabetic characters.
  • DBCS characters are scrambled to other DBCS characters.
  • Numerics are scrambled to other numerics.
  • Any other characters remain unchanged.
  • Repeatable scrambling produces unique results for numeric fields defined with Leading zeros set to YES, and all non-numeric fields.
• If you provide a value list, then the column is populated with a value from the list.
• If you provide a range, then the resultant number is in the range provided.
• If you specify a scramble type of random or repeatable and also the value option and a value data set, then the column is populated with a value from the data set.
• If you specify a scramble type of translate, then the input column value is matched and the corresponding output value is used from the value data set.