Using SoftBench with SQL

Using SQL with SoftBench Tools

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.

Chapter 13

319