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
- 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:
- From the Start menu, navigate to Settings > Control Panel > System.
- Click the Advanced tab and click Environment Variables.
- In the System Variables, click New.
The New System Variable window appears.
- Enter
SIEBEL_GENERATE_DDL in the Variable name field and Y in the Variable value field. Click OK.
- Continue to click OK until you are out of the System Variable window.
- 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.
|