![]() ![]() Developers also select the format of their results from this view (data, INSERT statement, XML, HTML, or XLS are the options), view the SQL archive, or pull up the table-data editor for previewing the SQL changes before committing. The split-paned and tabbed interface of the ADS query window gives SQL developers all kinds of shortcuts, including automated formatters, syntax coloring controls, auto completion, and auto describe features. ![]() The product’s query window is where the developers write and fine tune their SQL scripts. From the schema browser, users can visually edit many elements of their DB2/400 database, including tables, views, indexes, packages, sequences, stored procedures, triggers, aliases, nicknames, user-defined functions, materialized views, and user-defined datatypes. Like it does for other databases, ADS provides a way for developers or administrators to manage the DB2/400 database and write queries. (The folks at AquaFold labeled this database as “DB2 iSeries (formerly known as DB2 for i5/OS).” Technically, IBM calls it “DB2 for i,” but if you just use the informal “DB2/400,” everybody will know what you’re talking about.) The new entity relationship modeling feature in ADS version 7 gives users tools for exploring the relationships in their databases, including DB2/400.Īnother major new feature in ADS version 7 is support for DB2/400. This greatly reduces development time and can vastly improve a developer’s understanding of database schemas and relationships, the company says. What’s more, developers can modify an ER diagram and then have these changes applied to the database schemas (and the relationships they have with objects) by simply activating the automated scripting function in the product. With the launch of ADS version 7, AquaFold has expanded into the “fourth estate” of database maintenance: database entity relationship (ER) modeling.ĪquaFold says the new ER Modeler enables developers to create, explore, detail, and modify database schemas to create fully editable diagrams of database relationships and objects. Full clients for Subversion (SVN) and CVS source control systems enabled users to track all development and maintenance activity. The third area of focus was source control. The second area was a collection of comparison tools that allow users to view the differences of files, directory structures, source control files, and databases and schemas. Users can browse and modify any database from the product’s GUI and create SQL scripts. The first was graphical database administration and query. ![]() But that hasn’t stopped the growth of the tool, which today costs $399 and has more than 300,000 users around the world.īefore ADS version 7, the software focused on three areas of functionality for relational database management systems (RDBMs). The Java-based product was created in 2002 by company founder and CEO, Niels Gron, as freeware, and it soon went commercial. Last week the Silicon Valley company unveiled Aqua Data Studio version 7.0, which adds support for the DB2/400 (DB2 for i) database, brings a new entity relationship modeling component that should help developers better understand how their applications consume data, and support for seven languages.ĪquaFold bills its Aqua Data Studio as an integrated development environment that provides programmers, database developers, and systems administrators with a single, consistent interface to work with for all major database management systems. ![]() I-based Power Systems shops looking for a power tool to supercharge their database development and maintenance tasks may want to check out the latest release from AquaFold. AquaFold Adds DB2/400 Support to Database Tool ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |