|
Server Studio JE provides users with these free features:
You can also extend the Server Studio JE functionality with advanced add-on
modules , which provide server administration, performance monitoring,
schema and data management functions.
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.
Advanced SQL Editor Add-On Modules also provides a number of additional
features, such as build-in Query Execution Plan Viewer, support for data
LOAD/UNLOAD SQL statements, color-coding, ability to paste SQL/SPL templates and
more. Click here to find out
about Advanced SQL Editor add-on module.
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.)
More>
|
|
