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.
#DBVISUALIZER REVIEWS FOR FREE#
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 kommentar(er)
