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

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. 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=Y.
   • If using the Windows environment parameters, do the following:
     • From the Start menu, navigate to Settings > Control Panel > System.
     • Click the Advanced tab, and 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, which is found in the bin subdirectory of the Siebel Tools installation directory, by default, the C:\Program Files\Siebel\8.0\Tools directory.