Dumping Debug Variables and Referenced Table Data

Use the Dump Variable and Table Data dialog to configure variable logging and table data referenced by the procedural object in a debug session.

Prerequisites

Set the preferences for saving the dumping of debug variables and referenced table data in the Save Variable and Dump Reference Table Data Options in the SQL Debugger preferences.

When you open the procedural object editor and set the configuration for dumping, then go into the debug session, the system dumps the information according to the dumping configuration. If you close the procedural object editor, the dumping configuration is lost. If you want to dump information and reopen the procedural object editor, you must set the dumping configuration.

Right-click in the SQL Editor and select Dump Variable and Table Data from the context menu.
Select Dumping Variables to dump variables in a debug session.

(Optional) Select Dumping Referenced Tabled Data to dump referenced table data in a debug session. This option is disabled if there is no table data referenced by the procedural object in the debug session.

Option	Description
Tables	Select from the available tables, or click Select All, to configure the information for the available tables. Click Invert Selection to reverse the order of the tables.
Columns	Select the columns to dump, or click Select All. Click Invert Selection to reverse the order of the columns.
Where	Enter a where clause for the columns of the selected tables.
Order By	Enter an order by clause for columns of the selected tables.
Preview	Shows a preview of the SQL statement. the preview is updated according to the selection of the tables and columns and the criteria for the Where and Order By clauses.
Maximum Rows to Retrieve	Enter the number of rows to dump.

Click OK.