Server Studio™ Win32 features integrated database design, development, stored procedure and trigger debugging, analysis, optimization and deployment tools suite with support for a team development. Intuitive, easy-to-use graphical interface virtually eliminates the learning curve. Server Studio™ Win32 features seamlessly integrated suite of productivity tools for working effectively and efficiently with IBM Informix database servers.
Enterprise Edition is the most comprehensive edition of Server Studio™ — it provides a rich set of features for SQL application development, schema change management, database security management and support for a team development.
Professional Edition is a streamlined edition of the Server Studio™, geared primarily for SQL application developers.
|Execution Plan Analyzer|
|Version Control Manager|
- Operating System — Windows 95/98/NT/2000/XP
- Informix Client SDK — All versions of SDK are supported.
- Database Servers:
— Informix Dynamic Server (IDS) V. 7.x, 9.14, 9.2, 9.3
— Informix Extended Parallel Server (XDS) V. 8.3
Object Explorer is the integrated command center for all Server Studio™ Win32 tools and serves as a convenient central point for managing all connected database servers. It offers an easy-to-use interactive, function-rich system management interface that provides in-depth IBM Informix database catalog navigation by displaying and interpreting objects in the catalog, enabling you to quickly understand the structure of the entire database. Object Explorer displays the properties of database objects and lets you manage them with ease.
Object Explorer provides several different views:
SQL Editor is a powerful full-featured, color-coded editor, customized specifically to support Informix SPL and SQL languages. It allows you to write, edit, analyze and execute SQL and SPL statements and is able to display multiple servers' result sets in grid-style tab folders. SQL Editor provides complete syntax checking and supports nested objects cross-referencing. It enables you to apply SPL code templates, to execute individual code statements and provides standard block text operations such as comment/uncomment and indent/outdent. Another important and useful feature of the SQL Editor is its ability to estimate the cost of SQL statements execution. This capability enables you to tune SQL statements performance without the need to execute them on the server. Multiple SQL Editor sessions can be initiated with several databases using distinct user logins. Long running queries can be interrupted by the user at any time.
Table Editor allows you to visually create new database tables or edit existing ones. With it you can create and edit all table attributes such as columns, datatypes, table and index fragmentation, referential integrity constraints, primary and foreign keys. It also allows you to create or edit table indexes.
Data Editor enables you to interactively view 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. Data Editor supports editing data of any datatype including ROW TYPES, UDTs and COLLECTIONS.
Permissions Editor is an easy to use visual permission editor that hides the complexities of managing database security. It enables you to add new or edit the existing Users and Roles to a database, grant or revoke permissions for Users, Roles and databases objects, as well as assign Users to Roles and Roles to databases objects. Permissions Editor's flexibility makes it equally easy to manage permissions for a group of databases objects, Users or Roles as it is for a single one. Editing an existing database object, such as a stored procedure or a view, requires first dropping it, then re-creating it anew, which results in a loss of previously defined permissions for that object. Recovering permissions after each object modification is a tedious and an error-prone job. Permission Editor solves this problem by automatically recovering and applying all prior permissions to any object after it has been modified.
SPL Debugger is the only interactive debugger for Informix database servers' stored procedures and triggers available on the market and contains powerful capabilities usually found only in high level programming languages. It enables you to execute stored procedures and triggers line-by-line, to step into nested procedures or fired triggers, to set breakpoints, to watch and to modify values of procedures' variables and calling arguments, break infinite loops, etc. Simultaneous debugging sessions can be initiated from any workstation on the network. SPL Debugger can be invoked from any client application or development tool, such as Visual Basic, C++, Informix-4GL, etc. and can "hook" into a stored procedure or trigger already executing on the server, enabling you to identify the cause of an infinite loop or to pinpoint the slowest portion of the code. SPL Debugger supports watching and editing all types of variables, including UDT, OPAQUE and COLLECTION datatypes. Typical uses for SPL Debugger are:
Reference Analyzer is a powerful impact and reverse analysis tool, which enables you to determine the effect that the 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. Reference Analyzer returns all stored procedures, triggers and views that contain references to the selected object of interest and identifies 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 it's associated line of source code, which will automatically launch in the SQL Editor. Typical uses for the Reference Analyzer are:
Difference Analyzer is a powerful change management tool that allows you to perform comparative syntax analysis of stored procedures, triggers, views or any script file, regardless of whether they are located on the same or on different servers. You can easily compare individual database objects, files or text in an open SQL Editor.
Difference Analyzer employs color coding, auto aligning and synchronous scrolling of the "old" and "new" sources to make it easy for you to visually compare the differences in the source code. It is seamlessly integrated into Server Studio, enabling you to call it from any other tool (such as Object Explorer), and to switch immediately to editing mode once the difference in the code has been found.
Dependencies Analyzer enables you to examine all complex source and data dependencies of any selected database object with a single click of the mouse. The generated dependency tree is created to the required levels of nesting and contains all database objects (such as stored procedures, triggers, tables and views) that are dependant on the selected object of interest. Such dependency tree gives you complete picture of the entire application logic associated with the database object being examined. This capability is especially useful when analyzing legacy code, or code written by other developers. Dependencies Analyzer is also very helpful in documenting server-side application code.
For example, you run a stored procedure and it produces an unexpected or incorrect result. By running a dependencies analysis on this procedure, you can immediately find out that your procedure inserts some data into the table which fires a long forgotten trigger, which in turn executes yet another procedure that is the actual culprit of your data corruption. Trying to resolve this type of a problem by conventional means might have taken you hours of tedious debugging work, however, with the help of the Dependencies Analyzer you can accomplish it in minutes.
Execution Plan Analyzer graphically displays complete IBM Informix optimizer execution plan for a given SQL statement or executed stored procedure. It allows you to visually identify bottlenecks and tune the performance of your SQL application. You can set up a custom highlighting criteria based on Estimated Cost of an SQL statement to bring attention to potentially problematic segments of code.
Execution Plan Analyzer is seamlessly integrated with the SQL Editor and you can configure it to automatically run performance analysis for every statement executed from the SQL Editor. Execution Plan Analyzer makes it very easy to run execution plan analysis on any statement or a script and it enables you to try different tuning options and compare produced performance results. You can also open and view off-line explain plan files on the server, using a convenient tree-view visual presentation.