[an error occurred while processing this directive]
Update to utils2_ak package w/ v12.10 support
myschema.ec: Added support for new v12.10 features. Fixed syntax error in REVOKE EXECUTE commands when -O is enabled. New option --squish-triggers to eliminate white space in large triggers. New option -K to name auto-generated indexes using the table name rather than tabid and constrid. Fixed a bug in the -U option. Enhanced -v to print additional status steps. New option --no-storage-options to suppress IN clauses. Fixed a bug when -o and --drop-proc are used together. Fixed a bug in myexport support. Fixed --infrastructure to work with v9.40 and an output script bug if chunks have been dropped and new chunks added later.
ul.ec - Fixed include for inet.h on HPUX
dbcopy.ec - Fixed WITHOUT REPLICATION code. Added -O option to override restriction against copying a table onto itself. Added -E option to control the number of permitted errors before forcing an abort. Added support for new 2GB max fetch/put buffer. Fixed problem compiling on HPUX.
dbsavail.ec - Fixed KB calculations and blobspaces
Submiited by: Art Kagel 2013-05-06
Myschema: Fixed uninitialized variables.
Fixed memory overrun problem in print_procedures.ec.
Fixed handling of BIGSERIAL (again) for IDS versions prior to 11.50.
Added a new utility, dbscript, which takes a command and prints out a script to apply it to selected tables.
Moved an updated version of dbsavail.ec from utils_ak to utils2_ak with expanded reporting for newer IDS releases.
Submiited by: Art Kagel 2012-12-19
Myschema: Fixes to --infrastructure & --myexport-scripts. Fixed support for 7.xx engines. Improved sequence support. Dostats_ng: Expanded several internal strings to prevent memory overflows.
Submiited by: Art Kagel 2012-11-12
This update contains corrected calculations of the various sizing parameters output by the --infrastructure option.
Submiited by: Art Kagel 2012-08-26
dbdelete: Removed the progress printout if -S is specified and redirected the version printout to stdout from stderr.
dostats_ng.ec: Improved error printouts. Added a new option, --error-count, to return the number of errors encountered when -n
myschema: Fixed order by clause when -o is passed in. Fixed a problem affecting databases with more than 2^31 rows in any table.Added support for new option --index-online to add the ONLINE keyword to create index statements. Added support for foreign keys created with the INDEX DISABLED option. Fixes a compile time problem affecting AIX and other C compilers that do not recognize the C++ comment characters (//). Removed outdated warning about constraint indexes from the output. Fixed constraints printouts to support owners. Full support for -O and --set-owner are followed and constraint owners are printed by default.
ul.ec: Added support for NCHAR and NVARCHAR type columns. Thanks to Aleksander Kamenik for pointing out the omission.
dbstruct: Fixed output bug introduced with 4GL support. Fixed compile time problem on AIX.
sqlstruct: Fixed compile time problem on AIX.
Submiited by: Art Kagel 2012-08-13
New release of sqlcmd
SQLCMD 88.00 has been released to the IIUG Software Archive. Despite the new version number, it is mainly a maintenance release of SQLCMD, with fractional second sleep times being the primary feature of interest that was added
Updated by: Jonathan Leffler 2012-07-20
This script helps facilitate importing database data across platforms using External tables and PIPES.
Submiited by: Santosh Sajiip 2012-06-04
Decodes partnum/tblnum values.
Submiited by: Richard Harnden 2012-04-19
Updates to several utilities in the package:
Myschema: Shifted the implicit/explicit keyword to upper case for consistency. Fixed a bug that was ignoring casts from or to built-in(non-UDT) types.
Dostats: Fixed a bug in SET ISOLATION when executing immediately. Fixed a bug in --drop-distributions. Added --clean-distributions for cleaning out old distributions when only specific tables are being processed. Can be used globally, but --drop-distributions will tend to be faster. Restricted --drop-distributions from being used with -t, -x or -i since it would drop distributions from all tables and then only rebuild the distributions for the specified tables. Thanks to Ashok Sharma for pointing out these bugs.
Submiited by: Art Kagel 2012-01-30
|DBStudio||A free tool for fast SPL and query development|
|4glWorks||An application framework for Informix-4GL.|
|Aubit4GL||The Aubit Open Source Informix-4GL compatible complier and other 4GL development tools.|
|Server Studio||Server Studio JE with Sentinel - A comprehensive suite of tools to support IBM Informix databases from initial design, development and testing, through to production deployment and operational service [DBA, SPL, SQL]|
|IFxSQL||A database access tool for Windows that can make queries, execute scripts, export data, design reports, etc. The site's primary language is Spanish, but the tool's interface is straightforward.|