HP UX SoftBench Software manual Debugging Expanded SQL Statements, 320

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