eSQLEditor 5.18beta.

FreeWare program for Informix DBA and developers.

Download esqleditor518.zip (~900 kb). Screen shots.

Possibilities

Program shows list of tables or procedures by pattern of name, columns, indexes, etc; paste name of table or other database object to sql text by double click; execute sql scripts with timing and logging and show error place.

Requirements

Win2000/XP; Informix Connect/SDK 2.7 or higher.

Installation

Unzip archive, copy exe and xml(sql patterns) file to your folder. If upgrade version don't copy xml for saving own patterns. Folder must be writeable for saving ini file with parameters.

Supported

• Info about tables, synonyms, views (with text), columns, indexes, functional indexes, constrains (with check text), triggers (with text), procedures (with text), fragments, generate DDL (only test yet), depends from table (references - sysconstraints, views - sysdepend, synonyms - syssyntable).
• Syntax highlighting of sql text. Search and replace. Undo/Redo.
• Executing of sql scripts or selected part. Logging of executing with timings.
• Export to cvs, excel or html results of queries or tables data.
• Auto save text of SQL tabs, and all program parameters (font size, panels height and etc).
• In bottom-left corner in status bar shown estimated cost: estimated number of rows returned: number of rows processed after executing query.
• WarnOfUpdateDeleteWithoutWhere, WarnOfLargeQueryCost, WarnOfLargeNumberOfRowsRet.
• Queries with bind variables.

Unsupported

New IDS9 data types, sequences, permissions.

Hot keys

Switch between tabs Query/Result/Data/Log Alt+1(2,3,4).
Execute script Ctrl+E, execute selected Ctrl+Shift+E.

OnManager

OnManager is a program for DBA to see some stats and change permissions.

Download.  New home of the OnManager.

Features

• Server stats &mdash onconfig parameters, onstat -p, onstat -g seg, onstat -g glo, onstat -l, onstat -D, threads list, checkpoints list (IDS 11.50).
• Dbspaces layout &mdash onstat -d, onspaces commands, tables layout in dbspace/chunk, individual table size.
• User sessions &mdash onstat -u with flags, last SQL statement, used memory, error code, nsorts, connect time, isolation, active session filter.
The second page (SQLs) &mdash shows sysconblock for current sid.
• User locks &mdash locks list with waiters.
• User permissions &mdash grant/revoke rights on tables or procedures to users/roles. Generates script for object/grantee.
• Replications (ER) &mdash generates script to create replicates, shows existing replicates, and sending transactions. Works on IDS 9.3, other versions are not tested.
• Update info every seconds
• Run your own SQLs.

Requirements

Win2000/XP; Informix Connect/SDK 2.7 or higher.

Installation

Unzip archive, run exe file.