Online Documentation for SQL Manager for DB2

SQL Manager shortcuts


You can change shortcuts to your liking within the Global Shortcuts tab of the Environment options dialog.

 

Database management:

 

Shift+Ctrl+R

Register a DB2 node using Register Node Wizard

Shift+Alt+R

Register a database using Register Database Wizard

Shift+Alt+U

Unregister the selected database

Shift+Ctrl+C

Connect to a database

Shift+Ctrl+D

Disconnect from a database

 

 

Database objects management:

 

Ctrl+N

Create a new object (the object type depends on the current selection)

Ctrl+O

Edit the selected object in its editor

Ctrl+R

Rename the selected object

Shift+Del

Drop the selected object

Ctrl+Shift+C

Collapse the current DB Explorer tree branch and switch selection to the parent tree node

 

 

SQL Manager tools:

 

F11

View/hide Database Explorer

Ctrl+F

Search for an item in the DB Explorer tree

Shift+Ctrl+T

Open the To-Do List window

F12

Show SQL Editor

Shift+F12

Open a new instance of SQL Editor

Shift+Ctrl+M

Open SQL Monitor

Shift+Ctrl+S

Open SQL Script Editor

Shift+Ctrl+L

Open Localization Editor

Ins

Add a new table subobject (the subobject type depends on the current tab selection)

Ctrl+I

Start incremental search

 

 

SQL Editor and SQL Script (fixed and default):

 

F9

Execute query/script

Alt+F9

Execute selected only

Ctrl+Alt+F9

Execute under cursor

Ctrl+Alt+F2

Reset execution point (SQL Editor only)

Shift+Ctrl+<digit>

Toggle bookmark #<digit>

Ctrl+<digit>

Go to bookmark #<digit>

Ctrl+Q,N

Go to next bookmark

Ctrl+Q,P

Go to previous bookmark

F2

Drop marker to current position

Esc

Collect marker (jump back)

Shift+Esc

Swap marker to current position

Ctrl+Z;

Alt+BkSp

Undo

Shift+Ctrl+Z;

Shift+Alt+BkSp

Redo

Ctrl+F

Search for text using the Find Text dialog

Ctrl+R

Replace text using the Replace Text dialog

F3

Search next

Ctrl+I

Start incremental search

Alt+G

Go to line number (an input number dialog prompts for the number)

Ctrl+L

Load a script from an external file

Ctrl+S

Load the script to an external file

Shift+Ctrl+F

Format the SQL text using SQL Formatter

Alt+<symbol>

Switch to the query with <&symbol> in its name (SQL Editor only)

Ctrl+J

Insert a keyboard template

Сtrl+D

Toggle query results display mode (at the Edit tab or at a separate one)

Ctrl+Alt+Left

Switch to the next tab of SQL Editor

Ctrl+Alt+Right

Switch to the previous tab of SQL Editor

Ctrl+Alt+PgUp

Switch to the last tab of SQL Editor

Ctrl+Alt+PgDown

Switch to the first tab of SQL Editor

Ctrl+Q,S

Move cursor to beginning of line

Ctrl+Q,D

Move cursor to end of line

Ctrl+Q,R

Move cursor to absolute beginning

Ctrl+Q,C

Move cursor to absolute end

Ctrl+O,N

Normal selection mode

Ctrl+O,L

Line selection mode

Ctrl+O,C

Column selection mode

Shift+Ctrl+Left

Select the previous word

Shift+Ctrl+Right

Select the next word

Shift+Home

Select text to the beginning of the line

Shift+End

Select text to the end of the line

Shift+PageUp

Select one page up

Shift+PageDown

Select one page down

Shift+Ctrl+PageUp

Select text to the first line on the page

Shift+Ctrl+PageDown

Select text to the last line on the page

Shift+Ctrl+Home

Select text to the absolute beginning

Shift+Ctrl+End

Select text to the absolute end

Shift+Alt+Left

Select column symbol-by-symbol to the left

Shift+Alt+Right

Select column symbol-by-symbol to the right

Shift+Alt+Up

Select column upwards

Shift+Alt+Down

Select column downwards

Shift+Ctrl+Alt+Left

Select column word-by-word to the left

Shift+Ctrl+Alt+Right

Select column word-by-word to the right

Shift+Alt+Home

Select column to the beginning of line

Shift+Alt+End

Select column to the end of line

Shift+Alt+PageUp

Select column to the beginning of the page

Shift+Alt+PageDown

Select column to the end of the page

Shift+Ctrl+Alt+Home

Select column from the current cursor position to the beginning of the first line

Shift+Ctrl+Alt+End

Select column from the current cursor position to the beginning of the last line

Ctrl+Up

Scroll up one line with cursor position unchanged

Ctrl+Down

Scroll down one line with cursor position unchanged

Alt+Down, Alt+Up

Toggle case of a current word

Ctrl+Alt+Up

Toggle case to upper of a current selection or char

Ctrl+Alt+Down

Toggle case to lower of a current selection or char

Ctrl+G+T

Toggle folding

Ctrl+G,Ctrl+C

Collapse/Expand block at current line

Ctrl+G,Ctrl+F

Collapse block at current line

Ctrl+G,Ctrl+E

Expand block at current line

Ctrl+G,Ctrl+M

Collapse all blocks in the text

Ctrl+G,Ctrl+P

Expand all blocks in the text

Ctrl+=

Collapse/expand the nearest block

Shift+Ctrl+B

Jump to matching bracket (change range side)

Shift+Ctrl+I

Indent selected block

Shift+Ctrl+U;

Shift+Tab

Unindent selected block

Ctrl+/

Comment/uncomment selected block

Ctrl+Space

Show code completion

Ctrl+Alt+Space

Show character map

Shift+Ctrl+Space

Show code parameters

Ctrl+C;

Ctrl+Ins

Copy selection to Clipboard

Ctrl+X;

Shift+Del

Cut selection to Clipboard

Ctrl+V;

Shift+Ins

Paste Clipboard to current position

Ctrl+T

Delete from cursor to the next word

Ctrl+BkSp

Delete from cursor to the end of the previous word

Ctrl+B

Delete from cursor to the beginning of the line

Shift+Ctrl+Y

Delete from cursor to the end of the line

Ctrl+Y

Delete the current line

Ctrl+M;

Enter;

Shift+Enter

Break line at current position, move caret to a new line

Ctrl+Alt+I

Insert Tab char

Shift+Ctrl+R

Start macro recording

Shift+Ctrl+P

Play macro

Alt+End

Skip misprint

Ctrl+Alt+End

Skip all misprints

Alt+Home

Correct all misprints

Shift+Ctrl+Q

Save text as Favorite

 

 

Print Data View:

 

Ctrl+O

Load a printing report from a file

Ctrl+S

Save the report to file

Ctrl+P

Open the Print dialog

Ctrl+Home

Go to the first page

Ctrl+Up

Go to the previous page

Ctrl+Down

Go to the next page

Ctrl+End

Go to the last page

Ctrl+D

Open Report Formatter

Ctrl+\

Zoom 100%

Ctrl+0

Zoom page width

Ctrl+1

Whole page

Ctrl+2

Two pages

Ctrl+4

Four pages

Ctrl+W

Widen to source width

Ctrl+M

Show/hide margins

Ctrl+K

Set background color for the report

 

 

Working with windows, menus and tabs:

 

Ctrl+Tab

Switch to the next tab

Ctrl+Alt-0

Open Windows List

Ctrl+Alt+D

Set defaults to all windows

Ctrl+F6

Switch to the previous window

F6

Switch to the next window

Ctrl+W

Close the active window

Ctrl+Down

Expand a collapsed menu