Inserting Regions

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Data Sources and Targets > Databases and MapForce > Browsing and Querying Databases > Creating and Editing SQL Statements >

Inserting Regions

Regions are sections of text that you mark and declare as a unit to structure your SQL scripts. Regions can be collapsed and expanded to display or hide parts of SQL scripts. It is also possible to nest regions within other regions.

 

When you insert a region, an expand/collapse icon and a --region comment are inserted above the selected text.

 

Note:You can change the name of a region by appending descriptive text to the --region comment. The word "region" must not be deleted, e.g. --region DB2query.

 

 

To create a region:

1.In the SQL Editor, select the statements you want to make into a region.
2.Right-click and select Add Region from the context menu. The selected statements become a region which can be expanded or collapsed.

dbquery_region

3.Click the + or - box to expand or collapse the region.

 

 

To remove a region:

Delete the -- region and -- endregion comments.

© 2019 Altova GmbH