Online Documentation for SQL Manager for DB2

Merging queries


When editing the same query in several copies of SQL Editor, on attempt to close the SQL Editor window the Merging a Query dialog will appear like the one displayed below.

 

SQL Editor - Merging queries

 

 

The actions offered are the following:

 

RadioButton Save the both changed queries

The query opened in the first copy of SQL editor will be saved as its original name; the query in the current copy will be saved under the name with additional postfix (by default it is '_1').

 

RadioButton Use changes in the current copy of SQL Editor

The query will be saved as the original name; the modifications of SQL made within the current copy of SQL Editor will be applied.

 

RadioButton Ignore changes in the current copy of SQL Editor

The query will be saved as its original name; the modifications of SQL made within the current copy of SQL Editor will be ignored.