The SQL Debugger preferences specify the behavior of the SQL debugger and Referenced Tables view.
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. |
Property | Description | |
---|---|---|
External Client Session Detection Interval | Specify an integer for the interval in milliseconds as the maximum wait time for connecting to an external client while debugging. The default is 5000 ms. |
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. | |
Clear Logfile on Startup | Clears the dump log file 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. | |
Maximum Row to Dump Referenced Table Data | Specify the row count for dumping data. |