The IBM® InfoSphere® Optim™ Data Privacy solution provides user-defined functions (UDFs) you can use to mask Microsoft™ SQL Server data.
The following tables list the names of the UDFs for masking SQL Server data and their associated input and return data types.
UDF Name | Input data type | Return data type | Privacy provider |
---|---|---|---|
OptimMaskDate | DATE | DATE | AGE |
OptimMaskDouble | FLOAT | FLOAT | AFF, HASH |
OptimMaskInt64 | BIGINT | BIGINT | AFF, CCN, HASH, NID |
OptimMaskInt64Date | DATE | BIGINT | HASH |
OptimMaskInt64Double | FLOAT | BIGINT | HASH |
OptimMaskInt64NStr | NVARCHAR(800) | BIGINT | AFF, CCN, HASH, NID |
OptimMaskInt64Time | TIME | BIGINT | HASH |
OptimMaskInt64Timestamp | DATETIME2 | BIGINT | HASH |
OptimMaskNStr | NVARCHAR(800) | NVARCHAR(800) | AFF, CCN, EML, HASH, NID |
OptimMaskNum18S2 | DECIMAL(18,2) | DECIMAL(18,2) | AFF, CCN, HASH, NID |
OptimMaskNum18S4 | DECIMAL(18,4) | DECIMAL(18,4) | AFF, CCN, HASH, NID |
OptimMaskNum18S6 | DECIMAL(18,6) | DECIMAL(18,6) | AFF, CCN, HASH, NID |
OptimMaskTimestamp | DATETIME2 | DATETIME2 | AGE |
Use the multi-argument UDFs in the following table when you have more than a single column, expression, or literal as input to the UDF.
UDF Name | Number of arguments | Input data type | Return data type | Privacy provider |
---|---|---|---|---|
OptimMaskInt64NStr2 | 2 | NVARCHAR(800) | BIGINT | HASH |
OptimMaskInt64NStr3 | 3 | NVARCHAR(800) | BIGINT | HASH |
OptimMaskNStr2 | 2 | NVARCHAR(800) | NVARCHAR(800) | EML, HASH |
OptimMaskNStr3 | 3 | NVARCHAR(800) | NVARCHAR(800) | EML, HASH |