Siebel Database Upgrade Guide > Upgrading the Siebel Database > Process of Deleting Unshipped Languages from the S_LST_OF_VAL Table Under UNIX >

Importing Newly Created Records from the Data File Under UNIX

This task is a step in Process of Deleting Unshipped Languages from the S_LST_OF_VAL Table Under UNIX. Import the data file created when you backed up the S_LIST_OF_VAL table. This procedure is required to upgrade additional languages (those that were not available or skipped during the primary upgrade.) This step can be executed for multiple languages at once, or for one language at a time.

To import newly created records from the data file under UNIX

1. Create text file that will serve as input file for Siebel DATAIMP utility.

   NOTE:  The contents of the file must be formatted as follows (replacing <lang_code> tokens with actual values that represent the environment):

   S_LST_OF_VAL

   where LANG_ID in ('<lang_code1>', ..., '<lang_codeN>')

2. Save the file with the following extension .INP.
3. Navigate to ..\siebsrvr\bin directory.
4. From \siebsrvr\bin directory, execute the following command to run Siebel DATAIMP utility (replacing $ tokens with actual values that represent the environment):

   dataimp /u $UserName /p $Password /c "$ODBCDataSource" /d $SiebelTableOwner /f $DataFileName.dat /h Log /e N /i $InputFileName.inp /A 1

5. Check log file for errors.
6. Connect to the database using a database client that allows to run SQL interactively to verify that imported records are there.

   For example, you execute the following query:

   select count (LANG_ID), ACTIVE_FLG from S_LST_OF_VAL where LANG_ID = '<lang_code>' group by ACTIVE_FLG;

   If the result set returns both active and inactive records, then you must investigate and see why some records have been deactivated, and either re-activate or delete these inactive records.

Related Topics

About the Siebel Database Configuration Utilities

Starting the Siebel Upgrade Wizard