SQL Debugger Preferences

The SQL Debugger preferences specify the behavior of the SQL debugger and Referenced Tables view.

Table 1. SQL Debugger preferences: General
Property Description
Disable Breakpoint Toggling When the Editor Is Dirty
  • Always — always disable breakpoint toggling when the editor is dirty.
  • Prompt — prompt whether to disable breakpoint toggling (default).
Automatically Refresh ReferencedTables and Table's Contents When Debugging Refresh the Referenced Tables view whenever a table changes in the database so that you can immediately see changes made by other running procedures or other users. This preference is unselected by default.
External Client Session Detection Interval Specify a value in milliseconds as the maximum wait time for connecting to an external client while debugging. The default is 5000 ms.
Table 2. SQL Debugger preferences: referenced tables view display options
Property Description
Show Row Number Display the row number in the Referenced Tables view. This preference is selected by default.
Maximum Rows to Display Specify the maximum number of rows displayed in the Referenced Tables view. Enter 0 to display all rows. The default is 500.
Display Null Value As Specify the characters to display in the Referenced Tables view when the value from the database is NULL. The default is NULL.
Table 3. SQL Debugger preferences: Session detection
Property Description
External Client Session Detection Interval Specify an integer for the interval in milliseconds.
Table 4. SQL Debugger preferences: save variable and dump reference table data options
Property Description
Log file Save the variable content and the data of a table referenced by the procedural object in a debug session into a text file. Click Browse to choose the location of the dump log file path.
Rollover Frequency Select Daily, Weekly, or Monthly from the drop-down.
Clear Logfile on Startup This option is selected by default. When selected, the dump log file is cleared every time WorkSpace is started. This ensures that the dump log file does not get too large, which makes parsing and retrieving the data more efficient.
Row Count to Dump Reference Table Data Specify the row count for dumping data.
Parent topic: Setting Database Development Preferences
Related tasks
Debugging a Procedural Object
Debugging a Table in Referenced Tables View
Debugging an External Client
Dumping Debug Variables and Referenced Table Data

For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com