![]() If you have a moment, I highly recommend giving DbVisualizer a test drive.17:54:23,978 main ERROR There was a SQL exception checking for database driver correctness. I absolutely love that I have the ability to access two AS400 databases, a Microsoft SQL server, and a MySQL server all through one tool. Even better, you can connect to multiple databases at the same time. Common commands (SELECT, INSERT, UPDATE, & DELETE) are available to you from a list to cut down on unnecessary typing.Īll that being said, perhaps the best thing about DbVisualizer is that it works on any database. Primary Key Listing – If your table has keys defined, they will be listed through this option.Īdditionally, you also have the ability to run SQL commands directly through DbVisualizer.Row Count – While running a count through STRSQL is not overly difficult, the ability to have this option on a button makes it quick and easy to determine the number of rows in the table.Additionally, you have the added bonus of seeing more than 80 characters across at a time Some notable features that make this option stand out is the ability to filter out data and export data out to Excel. Data View – This option shows you the result set for the table you are examining.Field type, length, and other basic information are available through this option. Columns – A very basic listing of all the fields that exist in the file.Here is a brief recap of these useful tools: For starters, I am brought to a screen that gives me buttons for options, such as: Column Listing, Data View, Row Count, and Primary Key Listing. ![]() Not only does it show me a full listing of all of my tables, there is a lot of functionality too. I found the “Table” view to deliver the most functionality. After drilling into a specific library, you can then see tables, views, system tables, aliases, and procedures loaded into that library. After installation and setup, I am brought to a listing of all libraries on my database in a clean, well organized graphical interface. ![]() 95% of the time these tools were open exclusively for examining data through the SQL Manager.Īfter being frustrated that too many programs were running to do essentially the same thing, I kept thinking there has got to be a better way.ĭbVisualizer is a product that is available for Free (Though they also have options to purchase). Recently, I began noticing that I would have multiple AS400 sessions open, along with MS SQL Enterprise Manager.If I want to modify an SQL statement for some reason (recursive joins, union statements, nested sub-selects, etc…) in an m-Power application, I find it easier to test the statement first in SQL.Sometimes I work with databases that I am unfamiliar with, and I want to make sure that I grab the correct columns or tables for a report.When working with m-Power, I often find myself accessing the data-base through SQL for a variety of reasons:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |