dbTalk Databases Forums  

Update to utils2_ak posted

comp.databases.informix comp.databases.informix


Discuss Update to utils2_ak posted in the comp.databases.informix forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Art Kagel
 
Posts: n/a

Default Update to utils2_ak posted - 09-27-2011 , 07:54 AM






Friends:

The latest update to my utils2_ak package is now available. The README.1st
file is dated September 1, 2011. Here are the changes:

dostats_ng.ec:

- Added a new feature --proc_local which creates the table of commands
for the procedure to execute in each database rather than in sysadmin. This
is to support earlier Informix versions that do not have a task manager (so
no sysadmin database) and to support non-logged databases.
- Fixed a bug when running against an ANSI mode database.
- Fixed -i '!' processing to allow ORDER BY clauses in the query for
version 11 and higher that support derived tables.
- Restricted -x"!SELECT..." since -i can be used instead for this
functionality by negating the filters in the query.


myschema.ec:

- Fixed a problem that was preventing users with non-logged databases
from using myschema.
- Fixed a problem compiling with ESQL/C versions earlier than 3.50.
- Made changes to the --infrastructure feature to support versions of IDS
earlier than 11.xx that do not have dbschema -c support.
- Added new feature --drop-proc to optionally insert a drop procedure
statement before each create.
- Also added REVOKE EXECUTE FROM PUBLIC after the create. If public
should have privileges a grant to that effect will also be output.
- Fixed a problem with the makefile - it was missing linking
print_infrastructure.ec into the app.


Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
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.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.