IDS Forum

Re: New release of utils2_ak

Posted By: Art Kagel
Date: Thursday, 18 November 2010, at 10:24 a.m.

In Response To: Re: New release of utils2_ak (Peter_Logan@spartanstores.com)

Honestly Peter, I haven't tried. Someone offered me an AIX system to
compile test on, but I haven't had any time to work on my tools until this
week. I'll try to make time to figure out what the solution to the getopt.h
problem is.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.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.

On Thu, Nov 18, 2010 at 9:43 AM, Peter_Logan@spartanstores.com <
Peter_Logan@spartanstores.com> wrote:

> Hi Art,
>
> Does this new version compile properly on AIX?
>
> Peter Logan
> Senior Database Administrator
> Phone: 616/878-8309
>
> From:
> "Art Kagel" <art.kagel@gmail.com>
> To:
> ids@iiug.org
> Date:
> 11/18/2010 09:39 AM
> Subject:
> New release of utils2_ak [21979]
> Sent by:
> ids-bounces@iiug.org
>
> 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@iiug.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.
>
> --20cf30433f2a09629c049554bfb8
>
>
>
> *******************************************************************************
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--20cf30433f2ad1698104955561c9

Messages In This Thread

• New release of utils2_ak
  Art Kagel -- Thursday, 18 November 2010, at 9:38 a.m.
  • Re: New release of utils2_ak
    Peter_Logan@spartanstores.com -- Thursday, 18 November 2010, at 9:43 a.m.
    • Re: New release of utils2_ak
      Art Kagel -- Thursday, 18 November 2010, at 10:24 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.