I've just uploaded a new release of my utils2_ak package dated November 17,
2010 which will be online in a few days. There are a few bug fixes but the
biggest reason to download it is if you are using or considering using
Informix 11.70 (formerly known as Panther)! The latest release of myschema
(source version 2.235) supports all 11.70 features except the INDEX DISABLED
clause for foreign keys and has a new option --myexport-scripts that outputs
unload and load scripts for all of your tables using external tables! The
next release of myexport/myimport will use this new option to move your data
as quickly as possible!

Note that this release supports certain 11.70 features that are not yet
correctly supported by dbschema v11.70.C1 so utils2_ak is a MUST HAVE if you
are using 11.70 today!

Here's the full list of changes in the November 17th release:

dbdelete.ec: adds a new option, -o, that instructs dbdelete to not close and
reopen the fetch cursor between rounds of fetching keys or rowids to
delete. The purpose is to reduce (but not eliminate) the possibility of
deleting rows that have been inserted to the table during the dbdelete
run that match the selection criteria.

dostats_ng.ec: fixes an intermittent problem returning SQLCODE = -9971

myschema:
Added support for all 11.70 features except INDEX DISABLED foreign
keys. Note
that some are not yet properly supported by dbschema in v11.70.xC1!

Fixed -l (dbexport compatibility option) to ignore vercols, replcheck,
and erkey columns in the column count.

Adds support for WITH REPLCHECK, WITH ERKEY, and WITH AUDIT clauses in
CREATE TABLE.

Added options to support advanced myexport and myimport scripts using
external tables. Functional for IDS 11.70.xC1 and later.

Added new --create-conditionally feature to optionally add " IF NOT
EXISTS " clauses to object CREATE statements.

Added support for External Directives. New options
--suppress-directives
and --directives-only to control external directives output.

Support added for Forest of Trees indexes, Index Extent Sizing, List
Fragmentation, and Range/Interval Fragmentation.

Fixed compile time warnings in several files and a couple of bit test
logic bugs in print_puts.ec. Thanks to John Adamski for pointing these
out. Fixed a bug processing disabled triggers.

Added new option --wrap-to to specify the wrap column for trigger
output. Default is 80, min is 40, -1 means no wrapping. Fixed a bug
that line wraps quoted strings when the opening quote is not preceded by
a space. Thanks to Joseph Jurcazak for pursuing this one.

Fixed a bug that prevented sequence output for IDS 10.00 and 11.10
servers (oops). Implemented new option --sequence,
--sequence='matches-spec' to print only sequence definitions.

Fixed object state for unique and foreign keys. Reverted current value
detection to use the nextval function as dbschema does. Using the
sysactptnhdr record turns out to be unreliable. It doesn't seem to be
updated consistently.

dbcopy.ec: Fixed a variable declaration that causes compile time problems on
some platforms.

sqlstruct.ec: Fixed main loop exit and end of input detection. Fixed
compile
time warning on some platforms.


Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art (AT) iiug (DOT) org)
Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.