Skip to Content

Overview of the SQLX edit macro

The SQLX edit macro provides interactive explanation and execution of individual SQL statements and is valid anywhere you can edit Data Manipulation Language (DML) SQL.

You can use the SQLX edit macro in an ISPF edit session. You can access the text you want to process from a data set or enter the SQL in a TSO edit session.

The SQLX edit macro enables you to ensure that the data is being processed as intended by displaying the requested data rows. When the SQL statement is processing the data correctly, you can switch to the Explain function and tune the statement for optimal performance.

Related topic

Explaining-and-executing-an-individual-SQL-statement

You can only view the results of an SQLX Explain operation online.

Using the execution function of the SQLX edit macro, you can input values for host variables and execute an SQL statement in the foreground.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI SQL Explorer for Db2 13.1