advertisement

Toad for DB2 Tips & Tricks

29 %
71 %
advertisement
Information about Toad for DB2 Tips & Tricks
Technology

Published on February 27, 2014

Author: Michael_Micalizzi

Source: slideshare.net

Description

Learn how Toad for DB2 can simplify SQL development. See how to create & optimize SQL statements, view & analyze results sets, create professional reports and more.
advertisement

Toad™ for IBM® DB2® Tips & Tricks Become more productive with Toad

Want to get the most from Toad? This presentation will get you on your way to some of Toad’s most useful features. Learn how to setup and customize Toad, create and Optimize SQL statements, view and analyze result sets and more. 2 Software

Part 1. General setup configuration and startup 3 Software

Toad for DB2 Setup & configuration • Toad for DB2 enables you to control the look and feel of Toad as well as default Toad behaviors • Choosing your preferred layout and configuration settings. – The first Configuration Wizard will start up the first time you run Toad. It will walk you through choosing your preferred layout and configuration settings. 4 Software

Toad for DB2 Configuration & Setup You can invoke the Configuration Wizard from within Toad at any time. 5 Software

Startup Connections You can choose how connections should be displayed when you startup Toad. 6 Software

Starting up Toad for DB2 – Configuration Wizard • You can select which features should open automatically when a database connection is opened. • You can change your connections settings later, just use the Tools │ Options Menu item 7 Software

Toad for DB2 Startup Choosing what actions are performed at Toad startup The highlighted section in the below figure controls what actions are performed at Toad startup After clicking the Options menu item, you can change what actions are performed at startup 8 Software

Toad Startup Controlling whether Toad can access the internet If you need to ensure that Toad will not attempt to access the internet (for example to check for product updates), check the checkbox highlighted below 9 Software

Toad Startup Cataloging your databases Toad installs and uses its own DB2 client environment. The databases you will be accessing in Toad need to be cataloged within that Toad DB2 environment. When you first attempt to create a DB2 connection and Toad realizes that you do not have any databases cataloged, a dialog will open to help you import the database catalog from other DB2 environments you may have installed on your system. 10 Software

Toad Startup Cataloging your databases You can always catalog your databases using the DB2 Configuration Wizard shown below 11 Software

Toad Startup Specifying options for each database connection When you define a database connection, you can specify that it should connect automatically when Toad starts up 12 Software

Toad Startup Specifying options for each database connection You can choose which features open automatically when a new DB2 connection is established 13 Software

Part 2. The Database Explorer 14 Software

The Database Explorer The Database Explorer allows you to easily navigate through your database objects and view important information about those objects. It contains features that make it very powerful and it is highly customizable In this next section you’ll learn how to: 1. Create filters 2. Use the right-click menus to see many extra actions available 3. Use the dependencies tree to see Object relationships 4. Quickly generate SQL 5. View Object details 15 Software

To learn all about the Toad Database Browser and the rest of Toad’s productivity features download the entire eBook at https://software.dell.com/whitepaper/toad-for-ibm-db2-tips-andtricks825036/# Oh and by the way, you can also watch the on-demand webcast at https://software.dell.com/webcast-ondemand/productivity-tips-tricks-forthe-latest-version-of-toad-for-ibm-db2823128/ and get on your way to easier workdays with Toad! 16 Software

To learn more about ™ Toad for ® IBM ® DB2 Visit www.software.dell.com/toad-for-db2 17 Software

18 Software

Add a comment

Related presentations

Presentación que realice en el Evento Nacional de Gobierno Abierto, realizado los ...

In this presentation we will describe our experience developing with a highly dyna...

Presentation to the LITA Forum 7th November 2014 Albuquerque, NM

Un recorrido por los cambios que nos generará el wearabletech en el futuro

Um paralelo entre as novidades & mercado em Wearable Computing e Tecnologias Assis...

Microsoft finally joins the smartwatch and fitness tracker game by introducing the...

Related pages

Toad for IBM DB2 - Toad World

Welcome to the Toad for IBM DB2 community. We invite your feedback on how to continue to improve. ... Toad for DB2 Tips & Tricks: Recent Posts. Show More. ...
Read more

Toad for IBM DB2 - Tips & Tricks - Toad for IBM DB2 Wiki ...

Home » Products » Toad for IBM DB2 » Toad for IBM DB2 Wiki » Toad for IBM DB2 - Tips & Tricks
Read more

Toad Tips & Tricks - Thatjeffsmith

Toad for Oracle Tips and Tricks Page 1 Toad Tips & Tricks Maximizing your Oracle productivity Jeffrey D. Smith aka @hillbillyToad ... Toad Tips & Tricks ...
Read more

Toad for IBM DB2 Tips and Tricks | Learn Toad's Most ...

Learn how Toad for DB2 can simplify SQL development. See how to create & optimize SQL statements, view & analyze results sets, create professional reports ...
Read more

Toad for IBM DB2 LUW | Database Software Tools for IBM DB2

For many years, Toad for DB2 has been a premier tool of choice for many DBAs to administer IBM DB2 on Linux, Unix, ... Toad for IBM DB2 Tips and Tricks
Read more

Toad Tips & Tricks - scribd.com

Toad Tips & Tricks ... for Oracle remains your „Go To‟ tool for anything Oracle. the Standard Edition of Toad is packed full of features. Toad for DB2.
Read more

Toad for DB2 Tips & Tricks - Technology - documents.mx

Learn how Toad for DB2 can simplify SQL development. See how to create & optimize SQL statements, view & analyze results sets, create professional reports ...
Read more

Toad for Oracle Tips and Tricks - Dell Software

Toad for Oracle has been the community’s tool of choice for more than a decade. With Toad, you are a member of an elite community of two million plus ...
Read more