DBArtisan Toolbars and Menus

Go Up to DBArtisan Product Design

DBArtisan offers multiple ways to navigate through the application:

• Main Menu
• Toolbars
• Shortcut Menus

For more information on customizing these items, see Customizing General User Interface Appearance.

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:

• Using Toolbar Viewing Options
• Understanding the Shortcuts Available on Specific 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

1. 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
Print	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

1. On the View menu, select Toolbars > Customize. The Customize dialog opens.
2. 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

1. On Desktop, right-click DBArtisan.

   DBArtisan opens the shortcut menu.

2. 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, C:\WINDOWS\NOTEPAD.EXE
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:

1. On the Tools Menu, select Customize.

   DBArtisan opens the Customize User Tools dialog.

2. Select options.
3. 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.