Modifying the Input File

Before upgrading to a higher encryption level, you must modify the encrypt_colums.inp input file to list every table column that you want to upgrade. The input file, encrypt_colums.inp, indicates the table and column that store the encrypted data, and the table and column that store the key index.

This task is a step in Process of Upgrading Data to a Higher Encryption Level.

The following procedure describes how to modify the input file.

To modify the encrypt_colums.inp file

1. Navigate to the SIEBEL_ROOT/dbsrvr/bin directory where the input file is located.

   If you want to run the Encryption Upgrade Utility from the command line, then place this file in the SIEBEL_ROOT/siebsrvr/bin directory.

2. Using a text editor, edit the input file to include every column that you want to upgrade.

   The first line of the input file indicates a table name with brackets around it. On subsequent lines following the table name, list all the columns to be upgraded for that table.

   Each column that stores encrypted data requires a table column to store the key index, which is specified after the column name; for example:

   [TABLE_NAME]
   COLUMN_NAME TABLE_NAME_FOR_KEY COLUMN_NAME_FOR_KEY  
   WHERE clause 
   

3. After each table, skip a line, and continue to list the columns for subsequent tables, as shown in the following example:

   [S_ORDER]
   CC_NUMBER S_ORDER CCNUM_ENCRPKEY_REF 
   WHERE S.CC_NUMBER='1234567890'
   [S_DOC_ORDER]
   CC_NUMBER S_DOC_ORDER CCNUM_ENCRPKEY_REF 
   WHERE S.CC_NUMBER='1231231231'
   [S_PER_PAY_PRFL]
   PAY_ACCNT_NUM S_PER_PAY_PRFL CCNUM_ENCRPKEY_REF 
   WHERE S.CC_NUMBER='1231231231'
   

4. When you have added information for every table column that you want to upgrade, save the input file.