Organizing your development environment in Toad for SAP Solutions

Hello, folks. My name is Robert Pound and, I'm a product technologist for Quest. This video will cover getting your development environment organized in Toad for SAP solutions. For this demo, I've already established a connection to an ASE database. In getting your environment set up, the first thing you'll want to do is ensure that you can view the productivity tools. I've already displayed some of them here. You may organize it a different way. But if SQL Recall, Toad views, or code snippets aren't visible, you can come to view and select any one of those tools. So in looking first at SQL Recall, we can see everything that's been run from this tool. We can, for instance, hover over a specific statement and see which statement that is, and also the connection information as well. Any one of these SQL statements that you want to view on a regular basis, you can send to the name tab in the SQL Recall by right clicking on a statement and choosing Move to Named. You will then name the actual statement. You can name them whatever you like. You can also send them to code snippets by choosing Add to Favorites folder. This will add it to the Favorites in code snippets for your particular database-- in this case, ASE-- or to Toad views. You can also highlight a statement if you want to send it to Toad views by right clicking and choosing Add to Toad Views. You can also do it from the query builder. So for instance, if you add a query that you want to add to Toad views-- for instance, this one here on screen-- I can right click on the canvas and choose Add to Toad Views. So I can treat it like a regular view, only it gets saved in the Toad environment, not on your database. And Code Snippets are handy for dropping in little bits of code that you don't have to continually look up. It's library of, as the term implies, code snippets. So if I have something that I want to drop in here, I can simply choose it from the list, and I can bring it in. And the definition is here at the bottom for each one of the Code Snippets. And as you can see, there are also-- in this particular script, I have designated regions. This allows you to minimize and maximize areas in the code so it makes it easier to read, easier to navigate. So you put in a comment with region and then the name of the region itself, and then you end it with End Region. And also looking at Script Map here on the left-- this will show you what is in the script, so you can navigate quickly to any one particular item. And since I've already put regions in, it will show the regions as well. So we can see what type of statement it is and where it is. Simply double click and go to it. And finally, Library. We can see it on the ribbon bar itself. So this allows you to save all particular files for a particular project here in one place. So instead of navigating through different file systems, you can save it all here. You can see that I have some SQL statements here, a connection, some other config files that I have with this particular project. And that's all I had to share on organizing and navigating your environment. For more information on this or other topics, you can check out the Help File. It has a wide ranging information to help get you started. You can also check out the community-driven innovation going on at www.toadworld.com. For more information on this product, visit www.quest.com/projects/toad-for-sap-solutions. Thank you, and have a great day.