Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390 > Customizing a Development Environment >

How to Spool DDL Generated by the Apply Button

The Siebel environment variable, SIEBEL_GENERATE_DDL, allows you to record DDL, generated by clicking the Apply button in Siebel Tools, into a file.

To spool DDL, generated by clicking the Apply button, into a file

1. Set the environment variable before running Siebel Tools on Windows by way of the command line or Windows environment parameters:
   • If using the command line, set SIEBEL_GENERATE_DDL=Y.
   • If using the Windows environment parameters proceed with the following instructions:
   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, click New.

      The New System Variable window appears.

   4. Enter SIEBEL_GENERATE_DDL in the Variable name field and Y in the Variable value field. Click OK.
   5. Continue to click OK until you are out of the System Variable window.
2. Open Siebel Tools and click the Apply button.

The DDL will be generated to the file output.sql, which is found in the $SIEBEL_ROOT/bin directory, where $SIEBEL_ROOT is the directory where Siebel Tools is installed.