|
Server Studio JE (Java Edition) is an operating system platform-independent,
enterprise-level, visual Integrated Development & Management Environment (IDME)
designed to provide - an open architecture - tools deployment platform that
serves as the common foundation for integration of current and future
development, deployment and management tools across the entire family of IBM
Informix database servers.
Server Studio JE, a collaboration effort between IBM Informix and AGS Ltd.,
represents a significant addition to IBM Informix product offering and
demonstrates its commitment to provide IBM Informix customers with
state-of-the-art application development and management tools.
Improve the manageability of your database
Server Studio JE features an intuitive, easy-to-use
graphical interface that virtually eliminates the learning curve and sets a new
standard for productivity in development, debugging, analysis, optimization,
deployment and management of database applications.
Object Explorer and SQL Editor
Core Functionality
Server Studio JE provides users with these free features:
- Database Object Explorer
- Properties Inspector
- SQL Editor
- Table Editor
Database Object Explorer
Object Explorer is the integrated command center for all Server Studio JE
tools and provides a convenient central navigation point to all connected
database engines. When connection to a database server is established, it
displays all available databases on that server and lists all available database
objects for each opened database. Object Explorer has its own toolbar to
expedite frequent operations such as Properties, Open, Create New, Refresh, etc.
and lets the User easily do the following:
- Establish and Manage database servers' connections.
- Examine and understand the structure of the entire database.
- Examine Properties of any supported object.
- Create any supported object.
- Edit any supported object.
- Delete any supported object.
SQL Editor
SQL Editor is a powerful, full-featured editor, customized specifically to
support IBM Informix SPL and SQL languages and enables writing, editing and
execution of SQL and SPL statements. SQL Editor provides the following
operations:
- Text editing of SQL and SPL statements and scripts.
- Multi-threaded, non-blocking execution of SQL and SPL statements or
scripts against a database server.
- Execution of the entire code or selected portions.
- Loading of a SQL script from a file.
- Stopping execution of SQL statements.
- Display of multiple result sets in spreadsheet-style grids ,using
dynamically generated output tab panels.
- Ability to open contents of the data in the query output grid in a
Hierarchical Cell Viewer.
- Support for all complex datatypes. For BLOB types the grid displays the
number of bytes in the retrieved data. User can then open Cell Viewer and
export entire binary content of BLOB data for the selected cell to a file.
- Syntax checking of entire code in the SQL Editor or just a highlighted
portion.
- Display of server error messages in Messages Panel.
- Display in Messages Panel of basic statistic information on the executed
SQL statements (such as number of rows affected by operation).
- Status bar displays the current execution status during asynchronous
statement execution.
- Ability to save query results to a text file.
- Search and Replace operations such as Find, Find Next, and Replace.
- Basic editing operations such as Copy, Paste, Cut, Clear, Undo, and Select
All.
- Basic file operations such as Save, Save As, and Open File.
Table Editor
Table Editor is a comprehensive visual editor for the creation of new
database tables or the editing of existing ones. It provides highly granular
access to all table attributes including columns, datatypes, table and index
fragmentation definitions, referential integrity constraints, and primary and
foreign keys. Table Editor graphically displays the following information for
the selected table:
- List of columns and column related information such as: datatype, length,
scale, precision and Primary Key flag.
- Tree view of existing indexes with index related information.
- List of Constrains.
- List of Foreign Keys.
- Display and execution of generated SQL statements required to create the
table.
- Display and execution of generated SQL statements required to modify the
table if the User does any alteration to the table structure.
- General table information (i.e. storage, fragmentation, etc.)
Extend when you need additional functionality
IBM Informix understands that your needs are changing over time. Therefore
the Server Studio JE infrastructure allows you to install new add-on modules
through its extensibility framework as soon as they become available from IBM
Informix or AGS Ltd. Some of these extended features are provided on a try and
buy basis in the standard distribution of the software. These include:
- Server Administrator
- DB Diff Analyzer
- Object Dependency Analyzer
- Data Manager
- Test Data Generator
- Permission Manager
- Advanced SQL Editor
- DB Schema Manager
Click here for more information about Server
Studio JE Add-On Modules.
Server Administrator - Chunk View
Perform multiple tasks at the same time
Server Studio JE makes use of a multithreaded architecture, just like your
IBM Informix Database Servers, that enables you to run any statement against a
database server and continue using the software. To minimize the required
connections towards your database engine, Server Studio JE is built around
connection pooling so that precious resources are used as sparingly as possible.
Not only can you continue using the software, but this feature allows you to run
multiple statements at the same time, speeding your work and making obtaining
facts for decisions faster and simpler than ever before. 
DB Difference Analyzer - Database Comparison Output
Product Requirements
Client Operating Systems
- Windows NT 4.0 SP6
- Windows 2000
- Linux
- Sun Solaris 2.6, 7
- Java Runtime Environment Version 1.3
Supported Database Servers
- IBM Informix Dynamic Server 7.X
- IBM Informix Dynamic Server 9.X
- IBM Informix XPS 8.3x
- IBM Informix Online 5.1
Server Studio JE includes the required JDBC Driver for database connectivity.
So there is no need to download and install additional software on the client
computer that is used for the product.
|
|
|
