Creating and Using Custom Variables

Oracle Argus Dossier enables you to create and use custom variables. Ideally, you should define custom variables after Oracle Argus Safety has been completely configured to allow for correct and complete SQL statements. Before attempting to create and use custom variables, please seek help from IT personnel.

To define custom variables:

1. Open the CFG_DSR_TEMPLATE_VARIABLES table.
2. Enter values in the following fields:

   Field	Field Value
   ID	Enter a unique number in this field. This number must be the next number in the number sequence. For example, if ID number for the last row is 100, the new row must have an ID number of 101
   VARIABLE_NAME	Enter the name of the variable to be used in the template. Use lowercase characters when entering this value. Do not use the # sign in the name.
   SQL_QUERY	Enter the actual SQL statement to be executed when the template parser processes the variable name.
   REPORT_RELATED	Enter a 1. The application ignores any other value.
   DELETE	This must be a NULL value. If you place any other value in this field, the application considers the variable deleted.