Validate the Optim data privacy user-defined functions for Microsoft™ SQL Server

Use the IOQMSSQLUDFTest.sql script to validate the Optim™ data privacy user-defined function (UDF) installation and configuration.

1. From a command window, change directory to the scripts directory where you installed the UDF software.
2. Enter the following command:

   sqlcmd -E -S ServerName\InstanceName -d DatabaseName -I -i IOQMSSQLUDFTest.sql

   where

   • ServerName is the host machine of the SQL Server instance.
   • InstanceName is the name of the SQL Server instance.
   • DatabaseName is the name of the database in which you installed the UDFs.

   This script tests the UDFs by running the UDF with sample data. The following example illustrates the results for the OptimMaskDate and OptimMaskTimestamp UDFs:

   OptimMaskDate
   
   ----------------
         2001-11-18
   
   (1 rows affected)
   ...
   OptimMaskTimestamp
   
   --------------------------------------
              2001-11-18 00:00:00.0000000
   
   (1 rows affected)