Getting started with Toad for DB2: Chapter 8 - Using Multiple Databases

Another thing I wanted to show you is we're connected to one database right now. You could connect to multiple databases at a time just by creating another connection. So I'm going to create another connection profile. I'm going to choose another one of my local databases. And I'm going to save my password and give it a different color just so we could see the differences when we connect to this database. So I was already connected to my sample database. Now I'm going to connect to my pod, 105A database. And you'll see now I've got two Database Explorer tabs. And they're color-coordinated because I associate colors with each connection type. And as you click on those, you'll toggle back and forth between the databases. There's a couple of things that you can see that will identify what database you are on. Of course, the color, if you look at the lower right hand corner of Toad, the active tab document that you're on is also reflected down there as well. So that gives you the ability, for example, if you wanted to bring up a list of indexes on one database and on another database you wanted to bring up a list of tables, you could do that. And you could just toggle back and forth and take actions from either database. So Toad gives you the ability to connect to multiple databases at the same time. And one could be an LUW database and the other one could be in a z/OS subsystem. So we support that definitely. And another other thing we give you is the ability to-- if you hover over a tab, you might be confused and you might be looking for additional information. So as you hover over a tab, we'll display the information that's associated with that tab. So that's another helpful way of identifying which connection, what document, each tab is associated with. So here I'm just going to very quickly bring up a SQL Editor with some SQL. So the way I'll do that is selecting a table, select Generate SQL. And you could generate all sorts of different SQL, but I'm going to say just Generate a SELECT statement to a SQL Editor Session. And the reason why I did that is, again, to highlight the color coordinating. So since I opened this editor up associated with my first connection, it is highlighted in green. And so it's another visual way that we allow you to identify what connection is associated with each tab.