To display debugging information for the replacement of macros and parameters in the SQL query entered, right-click the information icon in the Edit SQL Query dialog box when configuring the data provider and select Show debug output:
The debugging information is displayed below the data-entry field in the Debug Output pane:
To show/hide line numbers in the SQL editor pane, right-click the information icon and select Enable editor line numbers.