Skip to end of banner
Go to start of banner

How to improve the display of SQL source

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

Summary

The Show SQL option on the SQL Macro and SQL-query Macro allow the SQL source to be displayed after the result data. This is helpful for problem determination. It also provides a way for users to copy the SQL for use in a slightly different query. With Release 6.4, there are new options for controlling how the code is displayed. The SQL is normally displayed with the default code macro. The new Options for showing SQL code (showSqlOptions) parameter allows you to enter a list of macro parameters that will be applied to the code macro.

Moreover, if you have the Code Pro Macro macro installed, you can use those parameters as well. 

Example

This uses the more advanced code-pro parameters that show the source in a collapsed section.

After clicking on SQL:

  • No labels