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 toY.

   • 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, such as C:\Siebel\Tools_1.