C and C++ SoftBench User's Guide

Using SoftBench with SQL
Using SQL with SoftBench Tools
Chapter 13320
Debugging Expanded SQL Statements
With SoftBench Debugger you typically debug your program using the
original source code with the SQL statements. However, you may want to
debug your source code after the SQL statements have been expanded by
the SQL preprocessor. To debug the generated source file instead of the
embedded SQL file:
Project build 1. Select the target and choose "Target: Display on
Graph".
2. On the target graph's Display Dependencies option
menu button, select "Source File Dependencies".
3. Select the generated source code node you want,
then choose "Modify Properties…" on the popup
menu.
4. In the "Modify Intermediate File Properties"
dialog box, remove the debug compile mode option,
then select OK.
By overriding the normal compile mode for debugging,
the compiler does not create line number directive
information for the embedded source code file, but it
does generate debug information in the object file for
the generated source code file.
To debug expanded SQL statements for all files, create
a "NoDebug" version of the SQL package when you set
up your targets' build configurations. Using a text
editor, comment out the APPEND DEBUGMODE -g line in
the Proc package. See SoftBench Online Help topic
"Sharing Packages with Team Members" for more
information.
Old SoftBench Makefile Edit the Makefile and remove the compile mode
for the SQLDEBUG macro.
Other Makefiles and build scripts Edit the Makefile using whatever
control mechanisms the RDBMS vendor provides.