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 |