Server Studio for Informix

Server Studio for Informix is an integrated development environment (IDE) for DBAs and back-end developers. It is utilized in analysis, development, troubleshooting, maintenance and optimization of Informix server-side applications deployed on any platform. Server Studio features the following seamlessly integrated productivity tools: DB Object Explorer SQL Editor Table Structure Editor Data Editor Permissions Editor SPL Debugger Execution Plan Analyzer Object Dependencies Explorer Difference Analyzer Object Reference/Impact Analyzer Server Sessions Browser Project Folders Version Control for database objects Server Studio supports the following Informix database servers: Informix Dynamic Server 7.x, Universal Server 9.x, IIF 2000. For more information and to get your free evaluation copy, please visit us at: http://www.agsltd.com Server Studio Highlights: ---------------------------------- SQL Editor is a powerful full-featured, color-coded editor, customized specifically to support Informix SPL and SQL languages. It provides complete syntax checking without requiring actual code execution on the server and supports nested objects cross-referencing. SQL Editor enables you to apply SPL code templates, to execute individual code statements and to get back multiple result sets. Object Explorer allows you to visually browse database server objects tree, to display objects' properties and to build object dependencies trees. It also gives you ability to customize your workspace by creating virtual project folders to speed up your access to logically related database objects. Table Structure Editor allows you to create and edit structure of existing tables, including columns, index, primary and foreign key definitions, constraints, fragmentation, etc. All available table options can be modified via the set of simple wizards and all required SQL statements are automatically generated by Server Studio. Permissions Editor allows you to edit and modify user, role and object permissions and also create new users and roles in a database. It automatically generates and applies to a database required GRANT and REVOKE statements. Dependencies Explorer enables you to analyze all complex source and data dependencies of any selected database object with a single click of the mouse. The generated dependencies trees are created to the required levels of nesting and contain all database objects (such as stored procedures, triggers, tables and views) that are dependant on the selected object of interest. Reference Analyzer is a powerful impact and reverse analysis tool, which enables you to determine what effect will changes in one database object will have on other server-side application objects. It performs powerful searches for all references to a specific database object across one or multiple databases. The results of reference analysis return all stored procedures, triggers and views that contain references to the selected object of interest and identify each line of source code where such references were found. You can view and edit any of the found object's references by clicking on its associated line of source code. SPL Debugger is an interactive debugger for Informix database servers' stored procedures and triggers. It enables you to execute stored procedures and triggers line-by-line, to set breakpoints, to watch and to modify values of variables, etc. SPL Debugger can be invoked from any client application or development tool, such as Visual Basic, PowerBuilder, C++, Informix-4GL, etc. Data Editor enables you to watch and edit data in database tables and views using a "spreadsheet-style" grid with resizable and movable columns. Data can be visually filtered sorted and exported into a variety of file formats including ASCII, Excel, SQL, etc. Execution Plan Analyzer integrates with SQL Editor and allows viewing of server execution plans for SQL statements and stored procedures executed from SQL Editor. Execution Plan Analyzer is a powerful tool to optimize performance of your back-end applications. Session Browser enables you to browse active server sessions, to get all sessions details, including last SQL statement executed during the session, as well as to set auto-monitoring and logging options. For example, you can set up an option to refresh session information every 3 seconds and log SQL statements executed during the selected session into a text file. Project Folders enable you to logically organize database objects into virtual folders within the Object Explorer. Project Folders support shortcuts to database objects (such as procedures, triggers, tables and views) at any desired level of nesting and permit multiple shortcuts to the same database object to reside in different project folders. Version Control allows you to maintain multiple revisions of stored procedures and triggers and automatically saves a several instances of dropped objects for instant recovery. It also enables locking of database objects for exclusive use in a team development environment. Sales Department Advanced Global Systems, Ltd. sales@agsltd.com www.agsltd.com