Keyboard Shortcuts - IBM Database Add-Ins for Visual Studio

In this topic:

Keyboard command	What it does
Alt+E	Moves the focus to the box in the Pre-Run Script section
Alt+P	Moves the focus to the first cell of the grid in the Parameters section
Alt+O	Moves the focus to the box in the Post-Run Script section
Alt+T	Moves the focus to the Execute button
Alt+M	Commits the SQL procedure to the database after you execute the procedure
Alt+H	Opens the Help topic that describes the fields in the Run Options window

Keyboard command	What it does
Alt+J	Moves the focus to the first cell of the grid in the Options section
Enter	Opens the SQL Condition window (if focus is on a cell in the Filter column of the options grid)
Alt+I	Moves the focus to the first cell of the grid in the Result Data section

Use the following shortcut keys in the Mapping Editor section of the Annotated XML Schema view of the designer.

Table 3. IBM XML Schema Mapping Designer commands

Keyboard command	What it does
Ctrl+T	Moves the focus to the root-level node in the Source XML schema pane. Use the arrow keys to navigate through the nodes in the XML schema.
Ctrl+G	If the focus is in the Source XML schema pane, moves the focus to and selects the first target table in the mapping editor. If the focus is in the mapping editor, moves the focus to and selects the next target table in the mapping editor.
Ctrl+J	If a table is selected in the mapping editor, selects the first map link for the table. If a map link is selected in the mapping editor, selects the next map link for the same table.

To add a map link by using the keyboard:

If the focus is on a table, press Ctrl+T to move the focus to the root-level node in the Source XML schema pane.
Use the arrow keys to move the focus to the node in the XML schema that is the source node for the new map link.
Press the Menu key to display the shortcut menu, press the down arrow key to select the Add Map Link command, and then press Enter.
Press Ctrl+G to move the focus to the first table in the mapping editor, and then press Ctrl+G repeatedly to move the focus to the table that contains the target column.
Display the shortcut menu, select Add Map Link, and press the right arrow key to display the submenu. Press the down arrow key repeatedly until the target column is selected in the list, and then press Enter.

To specify a value for the Content Handling or Normalization property of a map link by using the keyboard:

Select the map link in the Mapping Editor section of the Annotated XML Schema view of the designer.
Press the Tab key to move to the Properties section of the view.
Press the down arrow key repeatedly to navigate to the Content Handling or Normalization property.
Press the Tab key to move to the value cell of the property.
Press Alt+down arrow to display the list in the cell, press the down arrow key to move to the property value that you want to select, and then press Enter.