Using SoftBench with SQL

Using SQL with SoftBench Tools

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 -gline 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.

320

Chapter 13