Selecting Build Options and Running the Build Process

Access the Build dialog box.

Field or Control	Description
Build Scope	This list box displays all of the definitions that are included in the current Build process. The records that appear in this list box cannot be selected or deselected. If you must narrow the scope of your build, do so before accessing the Build dialog box.
Build	Click this button to start the Build process. While the Build process is running, the Build Progress dialog box appears, showing the current record being processed, the record number being processed in the series, and the total number of records that comprise the build. To stop a running Build process, click the Cancel button. When the Build process completes, the Cancel button is unavailable, and the Close button is the only valid button.
Settings	Click this button to open the Build Settings dialog box, where you can view or change your options.

Note:

After the Build process begins, no runtime prompts appear until the process is complete. All events are written to the Build log.

Build Options

The Build Options group box enables you to specify what action you want to occur: Create Tables, Create Indexes, Create Views, Alter Tables, Create Trigger, or Create Sequences. If you select Create Tables or Alter Tables, Create Indexes is automatically selected by default. Also, if you select Alter Tables, Create Indexes and Create Trigger are automatically selected by default.

Note:

You can select both Alter Tables and Create Tables to run concurrently if the Skip table if it already exists option is enabled on the Create tab in the Build Settings dialog box. Otherwise, the system cannot determine whether you want to alter or recreate a table that already exists.

Build Execute Options

Field or Control	Description
Build script file	Select this option to review and update the SQL before running the script. This method is the safest.
Execute SQL now	Select this option if you do not want to invoke another program to run the SQL; the SQL runs as part of the Build process. The disadvantage of running the SQL immediately is that you have no opportunity to review the SQL before it is committed to the database.
Execute and build script	Select this option to review the SQL that the Build process just ran.

To run the SQL script file that the Build process generates, you must use a third-party SQL tool, such as Oracle SQL Developer or Microsoft ISQL/W. Most database vendors include a native command processor that you can run on the client or the server.

Note:

The Execute SQL now option is unavailable if you use the Alter Tables Build option. However, you can use the Execute and build script option when using Alter Tables. Selecting this option builds a script with the entire altered SQL. This script may help if errors are encountered during the alter process. However, if an alter process has multiple tables and an error occurs, the errors are reported to a log file and the process continues to the next table.