Using SoftBench with SQL

Configuring SoftBench with SQL

Configuring SoftBench with SQL

SoftBench fully supports embedded SQL source files in both project and external build models. For project build, SoftBench provides packages to include in your build configuration instructions.

Using Default SQL File Types

SoftBench recognizes an embedded SQL source file type by the file extension. Each file extension results in unique language-specific operations. Table 13-1shows the default file extensions used for a particular RDBMS. See SoftBench Online Help for additional information regarding file types.

Table 13-1

SQL File Extensions for C Language
RDBMS EmbeddedSQL FileExtensions

Informix .ec

Oracle .pc

C++ Oracle

.pC

Using SQL with Project Build

The basic steps in defining targets that use SQL are:

1.Create the embedded SQL source files and add them to the project:

•If you create the files from scratch in a SoftBench editor started from the main SoftBench window, then new files automatically become members of the project when you save them.

•If you have existing files, you can add them to the project by choosing "Project: Add File(s) to Project…".

2.Set up a build configuration that works for the targets in this application:

a. Choose "Builder: Manage Build Configurations…".

Chapter 13

315