|
|
|
Server Studio Win32 Edition
|
|
|
Server Studio Windows Edition was the
original product for Informix back-end development and stored procedure
debugging. It has been superceded by more comprehensive multi-platform
solution for DBAs and back-end developers - Server
Studio JE.
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 runs under
Windows 95/98/NT/2000 and features the following seamlessly integrated suite of
productivity tools:
|
|
Server Studio is available in Professional and Enterprise editions.
|
|
Professional
Enterprise
|
|
Object Explorer is the central control consol for the Server Studio and
provides a very convenient navigation point for Server Studio tools. Object
Explorer allows you to quickly understand the structure of the entire database,
to visually browse database objects tree and to display the objects' properties.
|
|
|
|
|
|
Highlights
|
•
|
Ability to view and navigate database objects organized by physical object types such as PROCEDURES, TABLES,
VIEWS and TRIGGERS.
|
|
|
•
|
Ability to view the properties of the TABLES and
VIEWS structures, TABLE INDEXES, as well as syntax for PROCEDURES, TRIGGERS and
VIEWS.
|
|
|
•
|
Ability to analyze all complex source and data dependencies of any selected database
object.
|
|
|
•
|
Ability to perform powerful impact and inverse
analysis searches for all references to a specific database object across a
single or multiple databases.
|
|
|
•
|
Ability to customize workspace by creating Virtual
Project Folders to speed up access to logically grouped database objects.
|
|
|
•
|
Ability to view and navigate User-Defined Types (UDTs') and
DataBlades database objects.
|
|
|
•
|
Ability to completely reverse engineer the SQL
CREATE statements for UDTs and database tables with a single click of the mouse.
|
|
|
•
|
Ability to explore the structure of tables containing complex datatypes
and to drill-down to its underlying basic datatypes.
|
|
|
•
|
Ability to
support team application development and to provide application life cycle
support via server-based Integrated Version Control System repository.
|
|
|
•
|
Ability to
support team application development and to provide application life cycle
support via server-based Integrated Version Control System repository.
|
|
|
•
|
Data Import and
Export Wizard.
|
|
|
|
|
|
Professional
Enterprise
|
|
SPL Debugger is the only
interactive debugger for Informix database servers' SPL stored procedures and
triggers available on the market and contains powerful capabilities, usually
found only in high level programming languages. SPL Debugger can be invoked
from any client application or development tool, such as Visual Basic,
PowerBuilder, C++, Informix-4GL, etc.
|
|
|
|
|
|
Highlights
|
•
|
Ability to execute stored
procedures and triggers line-by-line.
|
|
|
•
|
Ability to step into nested
procedures or fired triggers.
|
|
|
•
|
Ability to set breakpoints.
|
|
|
•
|
Ability to break infinite loops.
|
|
|
•
|
Ability to watch and modify
values of procedures' variables and calling arguments.
|
|
|
|
|
|
|
•
|
Ability to perform "Standalone"
and "Remote" debugging.
|
|
|
•
|
Ability to provide Overloading Support for User-Defined Routines (UDRs).
|
|
|
•
|
Ability to support UDTs, OPAQUE and COLLECTION
type variables.
|
|
|
|
|
 |
|
Professional
Enterprise
|
|
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.
|
|
|
|
|
|
Highlights
|
•
|
Ability to create
new database tables and indexes.
|
|
|
•
|
Ability to edit
existing database tables and indexes.
|
|
|
•
|
Support for all
table attributes and fragmentation.
|
|
|
•
|
Foreign Key
Wizard.
|
|
|
•
|
Preview of
generated SQL CREATE and ALTER statements.
|
|
|
|
|
|
Enterprise
|
|
Permission Editor provides you with an easy to use interactive means to manage security
of any
database. It enables viewing or editing of users, roles or database objects
permissions. Permission Editor dynamically generates SQL GRANT and REVOKE statements required to
manage all aspects of database permissions and they can be previewed, exported
to an external script file for later use.
|
|
|
|
|
|
Highlights
|
•
|
Ability to
view/edit database object permissions.
|
|
|
•
|
Ability to create
roles.
|
|
|
•
|
Ability to preview
generated SQL GRANT statements.
|
|
|
•
|
Ability to assign
users to roles.
|
|
|
•
|
Ability to
generate SQL GRANT and REVOKE statements for objects placed in the SQL Editor
and Table Editor. It allows automatically preserve existing object permissions
when SQL objects are modified from the Server Studio editors.
|
|
|
|
|
|
Professional
Enterprise
|
|
SQL Editor is a powerful
full-featured, color-coded editor, customized expressly to support Informix
SPL and SQL languages. It allows you to write, edit, analyze and execute SQL
and SPL statements.
|
|
|
|
|
|
Highlights
|
•
|
Ability to display multiple
servers' result sets in grid-style tab folders.
|
|
|
•
|
Ability to apply SPL code
templates.
|
|
|
•
|
Ability to perform analysis of
the Execution Plan.
|
|
|
•
|
Ability to retrieve all of Informix datatypes
including: UDTs, OPAQUE and COLLECTIONs.
|
|
|
•
|
Ability to
to display and traverse complex data using convenient hierarchical view of the
built-in Cell Viewer.
|
|
|
•
|
LOAD and UNLOAD statements support. LOAD and ULOAD
statement wizards.
|
|
|
•
|
Ability to interrupt long queries.
|
|
|
•
|
Ability to copy and paste a subset of cells of the
query result set.
|
|
|
|
|
|
Professional
Enterprise
|
|
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.
|
|
|
|
|
|
Highlights
|
•
|
Ability to visually filter and
sort data.
|
|
|
•
|
Ability to export data into a variety of file formats including ASCII, Excel, SQL, etc.
|
|
|
|
|
|
|
•
|
Ability to support all of Informix datatypes
including: UDTs, OPAQUE and COLLECTIONs.
|
|
|
•
|
Ability to create and modify complex and UDT data in database
tables using the built-in Cell Editor.
|
|
|
|
|
|
Enterprise
|
|
Dependencies Explorer enables you
to analyze all complex source and data dependencies of any selected database
object with a single click of the mouse.
|
|
|
|
|
|
Highlights
|
•
|
Ability to view complete
structure of the entire application logic associated with the database object
being examined.
|
|
|
•
|
Ability to generate dependency
tree to the required levels of nesting, encompassing all database objects
(such as stored procedures, triggers, tables and views) that are dependant on
the selected object of interest within a database.
|
|
|
•
|
Ability to analyze legacy code,
or code written by other developers.
|
|
|
|
|
|
Professional
Enterprise
|
|
Explain Execution Analyzer graphically displays a complete Informix optimizer
execution plan for a SQL statement or for a executed stored procedure. It is seamlessly integrated with
SQL Editor,
making it
very easy to run Execution Plan analysis on any statement or a script in the SQL Editor.
Explain Execution Analyzer allows you to try different tuning options and compare produced
performance results.
|
|
|
|
|
|
Highlights
|
•
|
Allows to visually identify bottlenecks and tune the performance of
any SQL application or script.
|
|
|
•
|
Allows to set up a custom highlighting criteria based
on Estimated Cost of SQL statement and to bring to attention potentially
problematic segments of code.
|
|
|
•
|
Allows to configure the program to automatically run
performance analysis for every statement executed from the SQL Editor.
|
|
|
|
|
|
Enterprise
|
|
Reference Analyzer is a powerful
impact and inverse 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 a single or multiple databases. The results of
reference analysis return all stored procedures, triggers, tables and views
that contain references to the selected object of interest and identify each
line of source code where such references were found. With the SQL Editor you
can view and edit any of the found object's references by clicking on it's
associated line of source code.
|
|
|
|
|
|
Enterprise
|
|
Difference Analyzer enables you to search for differences between entire databases,
individual database objects, source code of stored procedures,
triggers or any script files. It uses a color coding, auto aligning
and synchronous scrolling of 'old' and 'new' sources to make it
easy for you to visually compare the differences between sources
being compared.
|
|
|
|
|
|
Highlights
|
•
|
Allows to easily compare individual database objects,
source and
text files in the SQL Editor windows.
|
|
|
•
|
Allows to easily compare all objects located in
two databases on the same or different Informix servers.
|
|
|
•
|
Allows to switch
immediately into editing once the difference in the sources being compared has
been found.
|
|
|
|
|
|
Enterprise
|
|
Session Browser enables you to browse
active server sessions, to get all the sessions' details, including
the 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.
|
|
|
|
|
|
Enterprise
|
|
Project
Folders enable you to logically organize
database objects into virtual folders within the Object Explorer.
|
|
|
|
|
|
Highlights
|
•
|
Ability to create Project
Folders at any desired level of nesting.
|
|
|
•
|
Ability to place into the Project
Folders shortcuts to database objects (such as procedures, triggers, tables and
views).
|
|
|
•
|
Multiple shortcuts to the same database object can reside in different
virtual Project
Folders.
|
|
|
|
|
|
Enterprise
|
|
Version Control Manager provides support
for team application development and for application life cycle support via server-based
Integrated Version Control System repository. Multiple
versions of User-Defined Routines (UDRs) and Triggers can be stored in the repository
and locked for exclusive use.
|
|
|
|
|
|
Highlights
|
•
|
Ability to create multiple
revisions of User-Defined Routines and Triggers.
|
|
|
•
|
Ability to automatically save
user-defined number of last dropped versions of database objects and to
recover any of them at any time.
|
|
|
•
|
Ability to Lock/Unlock
User-Defined Routines and Triggers for exclusive use.
|
|
|
•
|
Ability to compare (via Server
Studio's integrated Difference
Explorer) multiple revisions of User-Defined Routines,
Triggers and of script files between each other.
|
|
|
•
|
Ability to implement Integrated Version Control System
with very simple and intuitive graphical user interface and without requiring
any external programs or special setup.
|
|
|
•
|
Ability to implement team development virtually
without any learning curve.
|
|
|
|
|
|
|
Server Studio provides comprehensive support for
Informix 9.x. series Universal Servers, including the Informix Internet
Foundation 2000.
|
|
|
|
|
|
Highlights
|
•
|
Support for UDTs, OPAQUE and COLLECTION variables in
the SPL Debugger.
|
|
|
•
|
User-Defined Types and DataBlade viewers in
the Object Explorer.
|
|
|
•
|
User-Defined Routines (UDRs) Overloading Support.
|
|
|
•
|
Cell Editor allows to create and modify complex and UDT data in database
tables.
|
|
|
•
|
Table Structure Explorer.
|
|
|
|
|
|
|
| |
|
| |
|
|
