New release of utils2_ak

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

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.

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