Using SoftBench with SQL
Using SQL with SoftBench Tools
Debugging Expanded SQL StatementsWith 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 |
| 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 |