Creating an Override File

To override an execution parameter (public variable or translate table) in a Data Privacy Project, first create a file as described below and then select it using the Extract - Data Privacy tab's Execution Parameters Overrides File field.

To create the file for overriding execution parameters in a Data Privacy Project

Create a file containing the override values in the following general format:

executionParm=overrideValue

The specific format for a list variable is as follows:

<parameter name>=LIST(<delimiter>)=val1<delimiter>val2<delimiter>val3

For example:

StateList=LIST(,)=GA,IL,NV,SC,MI,CA

Important

The execution parameter must have been defined in the 

Workbench for Eclipse

 user interface for the project.

Example

DPR project "project1" includes:

  • 2 translate tables, 'Title table' and 'Titles for HR dept".
    • The source table for 'Title table' is file 'ABC.TRANS'.
  • 2 public variables, 'scramvar' and 'altscram'.
    • The initial value for 'scramvar' is string '123abc'.
  • 2 execution parameters, 'Parameter1' identified the translate table 'Title table' and 'Param2Variable' identifies variable 'scramvar'.

At execution time, however, you want to override the defined execution parameters for translate table "Title table' with the new translate table 'ABC.NEWTRANS' and the initial value of the variable 'altscram' with the new string '789xyz'. The new translate table must have the same characteristics as the original one.

The resulting file will look like this:

Parameter1=ABC.NEWTRANS
 Param2Variable=789xyz

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*