Online Documentation for SQL Manager for DB2

Customize work with query/script text

To customize work with a query/script text you may:

Use Internal Link

This means that the name of the object existing on a database is highlighted in a query/script text. Such an object can be opened by holding the Ctrl key and clicking the object with a mouse.

Add Text Template

Keyboard templates allow you to type regularly used expressions and edit the existing ones quicker. Once you have defined the templates, you can use them in SQL Editor. When editing SQL text in SQL Editor, type a template name and use the Ctrl+J shortcut: the text associated with the template will be inserted automatically.

Use Automatic Completion (Object List)

You can call the autocompletion list by starting entering the first characters of the text and using the shortcut Ctrl + Space.

Customize Autocompletion List

Choose Options | Editor options in the main program menu, proceed to the Quick Code tab and define the list and quick code parameters.

Apply Automatic Formatting of Query/Script

Choose Quick Code | Format in the SQL Editor/SQL Script context menu or the Shift+Ctrl+F shortcut to apply automatic formatting.

Set Font and Query/Script Format at the Display tab

Choose Options | Editor options in the main program menu, proceed to the Display tab and define common font and format parameters for SQL Editor/SQL Script.

Set Font and Query/Script Format at the Highlight tab

Choose Options | Editor options in the main program menu, proceed to the Highlight tab and define font options for each element.

Note: If some font parameters are defined on the Highlight tab, they will be applied to the query/script text and not the ones defined on the Display tab.