Implementing Siebel Business Applications on DB2 UDB for z/OS > Customizing a Development Environment >

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 DDL, generated by clicking the Apply button, into a file

1. Set the environment variable before running Siebel Tools on Windows from the command line or using Windows environment parameters:
   • If using the command line, set SIEBEL_GENERATE_DDL=Y.
   • If using the Windows environment parameters, do the following:
   1. From the Start menu, navigate to Settings > Control Panel > System.
   2. Click the Advanced tab, and click Environment Variables.
   3. In the System Variables box, click New.
   4. The New System Variable window appears.
   5. Enter SIEBEL_GENERATE_DDL in the Variable name field and Y in the Variable value field, and click OK.
   6. 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, which is found in the SIEBEL_ROOT\bin directory (Windows) or the $SIEBEL_ROOT/bin directory (UNIX), where SIEBEL_ROOT is the directory where Siebel Tools is installed.