DBArtisan Toolbars and Menus
Go Up to DBArtisan Product Design
DBArtisan offers multiple ways to navigate through the application:
For more information on customizing these items, see Customizing General User Interface Appearance.
Contents
Main Menu
You can access DBArtisan's features from the Main Menu by clicking the menu name, and then selecting the target command on the sub-menu. The menus are context-sensitive, changing as you perform tasks. DBArtisan menu items include:
Menu Item | Description |
---|---|
File |
Create, open, close, print and save script files and result sets. Set application options and defaults. Note: When you open New, you have easy access to a new ISQL window, the DDL Editor, a Java file, or the Active Script. |
Datasource |
Create, modify, select, manage, connect to, and disconnect from datasources. Access database object editors. Access session recording for Tivoli integration. |
Utilities |
Access utilities to extract schema, migrate schema, export and import data, execute scripts, search databases, monitor process activity and locks, schedule tasks, and restore, manage, and backup databases. |
Logfile |
Activate/deactivate, open, flush, and annotate the DBArtisan application log. |
View |
Configure DBArtisan to hide or show toolbars, status bars, and windows. Access full screen mode. |
Tools |
Access customizable tools menu. Access installed DBMS connectivity utilities and server documentation. |
Analyst |
Opens the Space Analyst, Capacity Analyst, and Performance Analyst. |
Bookmarks |
Access and manage bookmarks. |
Window |
Cascade and tile open windows. Arrange icons. Toggle between open windows. |
Help |
Lets you access context-sensitive Help, link to IDERA on the Web, and see license information when you click About... |
Edit |
Edit and manipulate the text in your SQL scripts. Available only when an ISQL Window is selected. |
Query |
Execute and set query options for a SQL script. Available only when an ISQL Window is selected. |
Format |
Format the contents of result sets. Available only when a Result Window is selected. |
Toolbars
DBArtisan supports two classes of toolbars:
- Feature-specific toolbars appearing at the top of the window or panel of tools such as the Datasource Explorer and Datasource Navigator, Object editors, the ISQL editor, and the Analyst tools:
- For information on the functions provided by feature-specific toolbars, see the documentation for the associated feature.
- Optional-display toolbars, appearing in one or more rows below the menu bar.
You can hide or display the individual optional-display toolbars and they change to reflect the element of the application you are using. These toolbars contain buttons that are the fastest way to access commonly used features of DBArtisan.
The following topics provide information you need to work with optional-display toolbars:
- Note: You can set preferences as to the default toolbars displayed and their appearance. For details, see Customizing General User Interface Appearance.
Using Toolbar Viewing Options
DBArtisan offers standard Windows toolbar options such as docking, floating, and positioning toolbars.The only application-specific viewing option is the hiding or display of the individual toolbars.
To hide or display a toolbar
- On the View menu, select Toolbars and then select the specific toolbar you want to display or hide.
For information on the toolbars available and the commands available on each, see Understanding the Shortcuts Available on Specific Toolbars.
Understanding the Shortcuts Available on Specific Toolbars
The following optional-display toolbars are available using the Toolbars command on the View menu.
Analyst Series Toolbar
This toolbar offer shortcuts that open the Space Analyst, Capacity Analyst, and Performance Analyst tools.
Datasource Toolbar
This toolbar offers shortcuts that let you connect to or disconnect from a datasource, select a datasource and for Sybase ASE and SQL Server, select a specific database.
Main Toolbar
This toolbar has common application functions.
It offers the following shortcuts:
New |
Open |
Save |
Save All |
|
Send Mail |
Options |
New Datasource Explorer |
Output |
Describe Window |
Full Screen |
Log SQL |
Session Recording |
Find Object |
Registration Toolbar
This toolbar offers shortcuts to registering a datasource, editing a datasource registration, and unregistering a datasource.
SQL Edit Toolbar
This toolbar offers functions used in editing SQL:
It offers the following shortcuts:
Undo |
Redo |
Cut |
Copy |
Paste |
Insert File |
Paste SQL Syntax |
Paste SQL Statement |
Comment |
Undo Comment |
Upper Case |
Lower Case |
Match Token |
Find |
Repeat |
Replace |
Toggle Bookmark |
Previous Bookmark |
Next Bookmark |
Clear Bookmark |
Increase Indent |
Decrease Indent |
SQL Profiler Toolbar
This toolbar offer functions used when working with the Oracle Profiler.
It offers the following shortcuts:
Start Profiler |
Flush Profile |
Run Summary |
Run Detail |
Unit Summary |
Unit Detail |
Clear Profile Tables |
Stop Profiling |
Tools Toolbar
This toolbar offers functions otherwise available on the Tools menu.
It offers the following shortcuts:
Customize Tools Menu |
Find in Files |
Database Search |
Script Execution Facility |
File Execution Facility |
Scheduler |
Visual Difference |
Edit Data |
Build Query |
Table/Index Size Estimator |
SQL* PLus |
Code Workbench |
Import Data From File |
Utilities Toolbar
This toolbar offers functions otherwise available on the Utilities menu.
It offers the following shortcuts:
Schema Extraction |
Schema Migration |
Shema Publication |
Data Unload |
Data Load |
Database Monitor |
Server Configuration |
Windows Toolbar
This toolbar offers functionality for working with windows.
It offers the following shortcuts:
Cascade |
Tile Windows Horizontally |
Tile Windows Vertically |
Next |
Previous |
Windows |
Customizing General User Interface Appearance
DBArtisan lets you choose from a set of general visual application styles, dictate hiding or display of particular items, and select preferences for specific user interface elements.
To customize the general look and feel of DBArtisan
- On the View menu, select Toolbars > Customize. The Customize dialog opens.
- Click Apply at any time to implement any changes you have made and when finished, click Close. Use the following table as a guide for understanding and setting options on tabs of the Customize dialog:
Tab | Settings and tasks | |
---|---|---|
Toolbars |
Select the toolbars you want to display in the application. For information on the toolbars available, see Understanding the Shortcuts Available on Specific Toolbars. | |
Application Visual Style |
Select a visual style such as Microsoft Windows XP or one of the .NET options from the dropdown. Depending on your selection, the following options may or may not be enabled: Use default WIndows XP colors, OneNote style tabs, Docking Tab Colors, Allow MDI Tab Swapping, Enable Smart Docking, Enable Tab Menu, and 3D Rounded Docking Tabs. | |
Menu animations |
Lets you specify a menu animation style of UNFOLD, SLIDE, or FADE. | |
Menu Shadows |
Displays shadowed 3D effects. | |
Tools |
Lets you define external applications to run from the Tools menu of DBArtisan: the text displayed on the Tools menu command (Menu contents), the path and file name of the executable (Command), optional Arguments, and an optional Initial DIrectory. | |
Keyboard |
Category |
Select a general category for a hot key for the command. |
Commands |
Select a hot key command, based on the general category. | |
Description |
Displays the command description. | |
Set Accelerator for |
Select application area where you want new hot key to be active. | |
Current Keys |
Displays current hot key. | |
Press New Shortcut Key |
Press keyboard key or an unassigned F key. | |
Options |
Show ScreenTips on toolbars |
Select to display a ScreenTip when you hover your mouse over a button. For example, when you hover your mouse over the New button, DBArtisan displays the ScreenTip “New.” |
Show shortcut keys in ScreenTips |
Select to display a shortcut key in the ScreenTip when you hover your mouse over a button. For example, when you hover your mouse over the New button, DBArtisan displays the ScreenTip “New (CTRL+N).” |
Shortcut Menus
DBArtisan incorporates shortcut menus to give you another way to access object functionality. These menus mirror the functionality that you can access from application toolbars or the main menu.
Accessing Shortcut Menus
- On Desktop, right-click DBArtisan.
- DBArtisan opens the shortcut menu.
- Click the target shortcut menu command.
Keyboard Commands
DBArtisan provides a number of Keyboard commands that expedite IISQL Editor development. The table below describes the available keyboard commands:
Category | Action | Keyboard shortcut |
---|---|---|
General editing |
Delete one character to the left |
BACKSPACE |
Delete one character to the right |
DELETE | |
Cut selected text to the Clipboard |
CTRL+X | |
Undo the last action |
CTRL+Z | |
Redo the last undo operation |
CTRL+Y | |
Copy text |
CTRL+C | |
Paste the Clipboard contents |
CTRL+V | |
Extending selections |
One character to the right |
SHIFT+RIGHT ARROW |
One character to the left |
SHIFT+LEFT ARROW | |
To the end of a word |
CTRL+SHIFT+RIGHT ARROW | |
To the beginning of a word |
CTRL+SHIFT+LEFT ARROW | |
To the end of a line |
SHIFT+END | |
To the beginning of a line |
SHIFT+HOME | |
One line down |
SHIFT+DOWN ARROW | |
One screen up |
SHIFT+PAGE UP | |
To the beginning of a document |
CTRL+SHIFT+HOME | |
To the end of a document |
CTRL+SHIFT+END | |
To include the entire document |
CTRL+A | |
Moving the insertion point |
One character to the left |
LEFT ARROW |
One character to the right |
RIGHT ARROW | |
One word to the left |
CTRL+LEFT ARROW | |
One word to the right |
CTRL+RIGHT ARROW | |
Up one line |
UP ARROW | |
Down one line |
DOWN ARROW | |
To the end of a line |
END | |
To the beginning of a line |
HOME | |
Up one screen (scrolling) |
PAGE UP | |
Down one screen (scrolling) |
PAGE DOWN | |
To the end of a document |
CTRL+END | |
To the beginning of a document |
CTRL+HOME | |
Bookmarks |
Toggle bookmark on/off |
CTRL+F2 |
Go to next bookmark |
F2 | |
Go to previous bookmark |
SHIFT+F2 | |
Splitter windows |
Go to next pane |
F6 |
Go to previous pane |
SHIFT+F6 | |
Debugger operations |
Start Debugging |
CTRL+F5 |
Stop Debugging |
SHIFT+F5 | |
Step Over |
F10 | |
Step Into |
F11 | |
Run to Cursor |
CTRL+F10 | |
Step Out |
SHIFT+F11 | |
Describe from Cursor |
CTRL+D | |
Insert or Remove Breakpoint |
F9 | |
Toggle (Enable or Disable) Breakpoint |
CTRL+F9 | |
Edit Breakpoint |
ALT+F9 | |
Go |
F5 | |
Restart |
CTRL+SHIFT+F5 | |
Debugger windows |
Open or Close Watch Window |
ALT+3 |
Open or Close Variables Window |
ALT+4 | |
Open or Close Call Stack Window |
ALT+5 | |
Open or Close Dependency Tree Window |
ALT+6 | |
SQL Window |
Go to the Result tab |
CTRL+ALT+R |
Go to the Query tab |
CTRL+ALT+Q |
Customizing the Tools Menu
The Customize Tools Menu dialog lets you add up to sixteen commands to the Tools menu. You can associate any program that running on your local machine. You can use this feature to associate frequently used programs and commands, thereby adding functionality directly to the DBArtisan application. In addition, you can specify arguments for any command that you add to the Tools menu. You can use these arguments to decipher how you want to execute commands. DBArtisan includes many pre-defined arguments that let you customize the application.
During the initial installation, DBArtisan automatically adds the following items (if installed locally) to the Tools menu.
- ODBC Administrator
- Oracle Service Name Manager
- Sybase Open Client/Server Config
- Sybase Directory Service Edit (DSEDIT)
- SQL Server Network Library Config
- SQL Server Books Online
- DB2 Client Configuration Assistant
Customize User Tools Menu Dialog: DBArtisan lets you customize the Tools menu.
The table below describes the options and functionality on the Customize User Tools Menu dialog:
Option | Description |
---|---|
Menu Contents |
In the box, click the target command. |
Menu Text |
In the box, type the name of the tool as you want to appear on the Tools menu. |
Command |
In the box, type the path and name of the program for the new tool or click Browse to locate the program. For example, |
Arguments |
To pass an argument to the command, in the box, type any argument or click the Arrow, and then click the target argument. NOTE: To display a menu of pre-defined arguments, click the drop-down arrow next to the Argument box, and then select an argument from the list to insert the syntax into the box. |
Initial Directory |
To specify an initial directory, in the box, type the path and name of the file directory or click Browse to locate the file directory. |
Add Button |
Click to add a new command to Tools menu. |
Remove Button |
In the Menu Contents box, click the command you want to remove, and then click the button. |
Move Up Button |
Click to move the command up one position in the menu. |
Move Down Button |
Click to move the command down one position in the menu. |
Completing the Customize User Tools Menu dialog
To complete the Customize User Tools Menu dialog, do the following:
- On the Tools Menu, select Customize.
- DBArtisan opens the Customize User Tools dialog.
- Select options.
- Click OK.
Specifying Arguments
DBArtisan provides a number of pre-defined arguments that you can pass to programs that you have added to the Tools menu. You can specify an argument to be passed to a program for newly added commands by choosing one of DBArtisan's pre-defined arguments or typing in your own arguments. The table below describes the pre-defined arguments:
Argument | Description |
---|---|
$$FilePath$$ |
The complete filename of the current source (defined as drive+path+filename); blank if a non-source window is active. |
$$FileDir$$ |
The directory of the current source (defined as drive+path); blank if a nonsource window is active. |
$$FileName$$ |
The filename of the current source (defined as filename); blank if the non-source window is active. |
$$FileExt$$ |
The filename extension of the current source; blank if a nonsource window is active. |
$$CurLine$$ |
The current pointer line position within the active window. |
$$CurCol$$ |
The current pointer column position within the active window. |
$$CurText$$ |
The current text (the word under the current pointer position, or the currently selected text, if there is one.) |
$$CurDir$$ |
The current working directory (defined as drive+path.) |
$$CurDatasource$$ |
The name of the current datasource as defined in DBArtisan. |
$$CurUserID$$ |
The name of the current datasource user. |
$$CurPwd$$ |
The current datasource password. |
$$CurConString$$ |
The current connection string or server name. |
- Note: Arguments are case-sensitive.
The table below describes examples for using the pre-defined arguments and command-line arguments:
Command | Argument | Description |
---|---|---|
NOTEPAD.EXE |
$$FilePath$$ |
Launches Microsoft Notepad displaying the contents of the $$FilePath$$ argument. |
ISQL.EXE |
-U$$CurUserID$$ -P$$CurPwd$$ -S$$CurConString$$ -i$$FilePath$$ |
Launches ISQL, automatically connects to the current datasource using the current user name and password, and executes the contents of $$FilePath$$. |
SQLPLUS.EXE |
$$CurUserID$$/$$CurPwd$$@$$CurConString$$ @$$FilePath$$ |
Launches SQL*Plus, connects to the current datasource using the current user name and password, and executes the contents of $$FilePath$$. |
- Tip: DBArtisan lets you specify an argument in the DBArtisan opens the Customizing General User Interface Appearance.