Implementing Siebel Business Applications on DB2 for z/OS > Customizing a Development Environment > Roadmap for Creating Custom Extensions to the Siebel Schema >

Applying Schema Extensions to the Local Development Database

After your have customized the Siebel Schema by defining new tables or columns in Siebel Tools and in the storage control file, you must apply the changes to your test environment.

This task is a step in Roadmap for Creating Custom Extensions to the Siebel Schema.

NOTE:  Siebel Business Applications do not support customized database triggers. If you create customized triggers on your Siebel base tables, you must disable them before updating the logical database schema. You can re-create the triggers after the update is finished.

The following procedure describes how to apply schema extensions to a local Siebel development database.

To apply schema extensions to your local development database

1. In Siebel Tools, select the table containing the changes you want to apply to the database.
2. Click Apply/DDL in the Object List Editor.
3. Select one of the following options and click OK.
   • Apply. Select this option to apply the changes you have made directly to the database.

     If you are connected to a local database, a message box appears, alerting you that your changes will be applied to the local database only. Click OK to continue.

   • Generate DDL. Select this option to write the DDL to implement the repository changes to a file. You can apply the DDL against the database later.

     The Apply Schema dialog box appears.

4. Fill in the fields as described in the following table, and then click either Apply or Generate DDL, depending on the option you selected in Step 3.

   Field	Description
   Tables	Select one of the following options from the drop-down menu: All. Updates the database to reflect all changes made to the dictionary. This option forces each database object to be compared with the data dictionary, and updated if required. Current Query. Updates the database to reflect modifications made to the tables in the current query only. Current Row. Updates the database to reflect modifications made to the table in the current row only.
   Table space	You do not have to set a value for this field on DB2 for z/OS.
   16K table space	You do not have to set a value for this field on DB2 for z/OS.
   32K table space	You do not have to set a value for this field on DB2 for z/OS.
   Index space	You do not have to set a value for this field on DB2 for z/OS.
   Storage control file	Specify the complete path to the storage control file you updated with the new object definitions as described in Amending the Storage Control File for New Schema Objects. For example: C:\siebel\8.2.2.0.0\ses\dbsrvr\db2390\storage.ctl. The storage control file includes information about table spaces or index spaces associated with the new objects you are applying. If you do not specify table space or index space information for new objects in the storage control file, the values specified in the Defaults object are applied.
   Database user	Enter the ID of a database user with CREATEDBA or DBADM privileges. The schema qualifier is read from tools.cfg.
   Database user password	Enter the password of the database user you specified above.
   ODBC data source	Verify that the ODBC connection specified in the ODBC Data Source text box is correct for your environment. You cannot apply schema changes to any database other than the one you are currently connected to (for example, by specifying the ODBC name of a different database).
   DDL File	Specify the name and location of the file where you want the DDL to be stored (only applicable if you selected the Generate DDL option in Step 3).

   Depending on the option you selected (Apply or Generate DDL), your changes are either written directly to the database or the DDL to implement the changes is written to the file you specified.

5. To activate extensions to EIM tables, select the appropriate tables, and then click Activate.

Spooling DDL Generated by the Apply Button

The Siebel environment variable, SIEBEL_GENERATE_DDL, allows you to record into a file the DDL that is generated when you click the Apply button in Siebel Tools.

To spool the DDL generated by the Apply button to a file

1. Before running Siebel Tools, set the environment variable from the command line or using Windows environment parameters:
   • If using the command line, set SIEBEL_GENERATE_DDL to Y.
   • If using the Windows environment parameters, do the following:
     • From the Start menu, choose Control Panel, and then the System option.
     • Click the Advanced tab, then click Environment Variables.
     • In the System Variables box, click New.
     • The New System Variable window appears.
     • Enter SIEBEL_GENERATE_DDL in the Variable name field and Y in the Variable value field, and click OK.
     • Continue to click OK until you are out of the System Variable window.
2. Open Siebel Tools, and click the Apply button.

The DDL is generated to the file output.sql in the bin subdirectory of the Siebel Tools installation directory. The default Siebel Tools installation directory is C:\Siebel\8.2\Tools_1.