ezSQL is a NonStop SQL/MP database management tool, enabling easy control and management of all your database environments. The intuitive and easy to use Windows based workstation ezSQL GUI greatly simplifies database management, providing functionality for easy and efficient operation and management of SQL/MP environments and objects, enablng DBAs and application developers both to be more productive.
Via the ezSQL GUI, users browse SQL objects in a "tree view," allowing "drill down" access to any level of detailed object property information, SQL object management, and generation of DDL describing these objects.
Using a unique visual diagram, ezSQL users can effortlessly design, develop, and test SQL queries, with no need for SQLCI expertise, and with no need to type long and cumbersome SQL statements. ezSQL enables complete query execution control, and allows configuration of attributes like auto-commit, initial fetch count, and secondary fetch count (just to mention a few!).
The ezSQL GUI also allows TNS file system browsing using a tree-view in Explorer-like windows, providing functionality for complete file management as well as file information access, via familiar Windows client features such as drag and drop, cut and paste, sorting, and so on.
ezSQL helps simplifying tedious and repetitive database management tasks like update statistics, SQL compilation, and database reload, making DBA routine work a snap. Through ezSQL, these and many other routine tasks may be configured (registered) with various run time options and task grouping, to be automatically scheduled at configured time intervals.
With ezSQL, the DBA can control query execution on a per-user basis, by enabling specification of executable query types and maximum query costs for each individual user, features that give the DBA very efficient control of and access to database and use system resources.
ezSQL supports localization using double-byte character definitions, enabling easy adaptation to any language, allowing users to access help text and error message information in their own language.