C and C++ SoftBench User's Guide

Using SoftBench with SQL
Using SQL with SoftBench Tools
Chapter 13 319
Using SQL with SoftBench Tools
You can use embedded SQL source files with Builder, the SoftBench
editors, SoftBench Debugger, SoftBench Static Analyzer and SoftBench
CodeAdvisor.
Using SQL Preprocessor Wrappers
Working with your original SQL source code is often simpler than
working with the expanded SQL statements that the RDBMS sends to
the compiler. To provide line numbers that reflect your original source
files,SoftBench provides a preprocessor wrapper which the compiler uses
to insert line number directive information into the object file. SoftBench
automatically invokes these preprocessor wrappers when a file with an
SQL type extension appears in a project build. Builder, SoftBench
CodeAdvisor, SoftBench Static Analyzer, and SoftBench Debugger use
the line number information to point back to the original SQL embedded
source code.
For external build projects, SoftBench tools refer back to the line
numbers in the file specified within your object file. Refer to your
RDBMS preprocessor documentation for information on generating line
numbers through your Makefile.
Debugging with SQL
SoftBench Debugger performs debugging of applications using the
original source code (with embedded SQL statements). SoftBench
Debugger treats embedded SQL statements as one single statement in
the source language for breakpoints and stepping operations. SoftBench
Debugger sets breakpoints at the beginning of an SQL statement.