IIUG Insider (Issue #225) April 2019

Highlights: IIUG software repository

Welcome to the International Informix Users Group (IIUG) Insider! Designed for IIUG members and Informix user group leaders, this publication contains timely and relevant information for the IBM Informix community.


1) Editorial
2) Highlights
   2.1 IIUG Software Repository
3) Conference Corner
   3.1 IIUG World 2019 – Call for Speakers closes June 1, 2019
4) RFE Corner
5) Informix Resources
   5.1 Informix Blogs and Wikis
   5.2 Social Media
   5.3 Forums, Groups, Videos, and Magazines


I was hoping to write about the IIUG World 2019 registration. We are almost there but not yet. So this issue is late. I plan to have new exiting conference news in the May issue which is due end of May.

We are all excited about the Informix new version 14.1. Having a new version shows that IBM and HCL are committed to Informix. Unfortunately, I do not receive much content form IBM and HCL. I think promoting the product should be a priority for both.

The IIUG is moving forward as well. If you are visiting our website you can see things are improving.

The IIUG Board is working hard on these improvements although a special thanks goes to Vicente Salvador, our Web Master, for doing most of it.

Our last edition, read more in the highlights is moving the IIUG software repository to SOURCEFORGE. Thanks to Eric Vercelletto for doing a great job.

More about new stuff in our next issues.

Stay tuned.

Gary Ben-Israel
IIUG Insider Editor
IIUG Board of Directors

2) Highlights

2.1 IIUG Software Repository

To get to the new IIUG software repository just go to resources at www.iiug.org

The IIUG Software Repository is hosted at SourceForge.

This Index allows you to browse and access the IIUG Software Repository. Entries have both a direct link to SourceForge resource and a Download link. A direct link will show the SourceForge page and display the content of the readme file, where one exists. A Download link will open a SourceForge page and initiate a download of the entire resource in tar.gz format.

Please read and heed the warnings, notices, and special instructions or agreements with each package.

Do you have some software you would like to contribute to the Repository? If so, check out the details on how to submit your files.

The resources are grouped as follows:

Data Warehouse Tools – Tools that can be used with data warehouse environments
DBAdmin Tools – Tools that help with database admin tasks
ESQL – ESQL programs and utilities

Informix4GL Tools – Programs and utilities in 4GL

InformixSQL Tools – SQL admin tools

JAVA Tools – Stored procedures and utilities written in Java

SQL Tools – Helpful SQL tools

Stored Procedures – Various stored procedures and utilities written in SPL

Miscellaneous – Everything else


Many entries have one or more keywords attached to them that indicate the general category of software and/or the source language(s) used. The keywords used in this index are:


ACE Report Programing Language


AWK Programing Language


GNU Version of yacc


C Programing Language


C functions for I-SAM files


cpp – C Language Preprocessor


Database Administration Utilities


ESQL/C Environment or ESQL/C Source


Informix-4GL Environment or Informix-4GL Source


Informix-SQL Environment


Perl Extension to Interface with Informix


Java Environment or Java Source


Korn Shell


lex – Lexical Analysis Program Generator


Large Scale Data Warehouse


Miscellaneous Routines and Utilities


New Era Environment or Source


Object-Relational Database Extensibility, DataBlades


Perl Programming Language


PHP Web Programming Language


Bourne Shell


Informix Form Generation Utility


Stored Procedures


SQL Scripts or General SQL Tools


Visual Basic


yacc – Yet Another Compiler Compiler

Gary Ben-Israel

3) Conference Corner

3.1 IIUG World 2019 – Call for Speakers closes June 1, 2019

IIUG World 2019 will be hosted by the Torrance Marriott, Redondo Beach (Los Angeles), CA, USA and will be held September 22nd – 26th, 2019

The hotel is beautiful and is just minutes from California’s Pacific Coast Highway and with its miles of beaches. Do not forget all the local attractions: Disneyland, Universal Studios, Knott’s Berry Farm, etc. It is convenient to LAX and Long Beach Airports. Find out more about this hotel /iiugworld/marriott.

The Call for Speakers is open. You have until June 1, 2019 to submit your abstract for IIUG World 2019. There will always be speakers from Informix development and support educating us about the latest and greatest features of the brand new version 14.1. However, it is important to have user speakers. I bet there are many of our users who have different techniques and methods of accomplishing your business needs using Informix. We would love to hear from you. We have a lot to learn from each other. So don’t hesitate, login to the speaker site and submit your presentation. The speaker site can be reached from the conference site or directly at: /iiugworld/speakers/2019. Selected speakers receive a free pass to IIUG World 2019. The pass includes everything starting with the Sunday, September 22th, Welcome reception through the last technical session on Wednesday, September 25th.

Conference registration should be ready shortly. An email will be sent when IIUG World 2019 registration is open.

Please visit the conference site at: https://www.iiug.org/iiugworld for additional details.

See you in September,

IIUG World Planning Committee

4) RFE Corner

IBM has created a new RFE – Request For Enhancements website.

It looks cool and is easier to work with


Please visit this site vote for your favorite enhancements or place a new request.

Added last month:




Automatic Statistics table exclusion list


Need review

Implement UUID keyword/function


Need review

Storing Large Objects in file system


Need review

Top 10




Backup from RSS or HDR Secondaries using ontape, onunload, onbar, dbexport


Future consideration

Obtain the query plan of a running query


Future consideration

SQL interface to obtain the temporary space usage (tables, hash, sorts…)


Future consideration

Backup Individual database, not entire instance


Future consideration

Informix should be able to change owner on tables and any other objects


Future consideration

Implement CREATE OR REPLACE option for stored procedures


Future consideration

New feature to have FORCE_DDL_EXEC functionality for all DDL changes


Need review

Ability to re-create views and procedures without dependent objects being dropped


Future consideration

Use of Adobe Flash in OAT is a security problem, please migrate to HTML5


Will not implement

Need an onmode option to terminate orphaned, tightly coupled global transactions. Onmode -Z does not address this case


Future consideration

Gary Ben-Israel

5) Informix Resources

IBM Informix home page
www.informix.com or directly at: http://www-01.ibm.com/software/data/informix/

IBM Informix community

5.1 Informix Blogs and Wikis

Blogs and Wikis that have been updated during the last month

More Blogs and Wikis

5.2 Social Media

Linkedin: https://www.linkedin.com/groups/25049

Twitter : https://twitter.com/iiug

Facebook : https://www.facebook.com/IIUG.Informix

Informix IoT Channel : https://ibm.biz/BdH2nm

5.3 Forums, Groups, Videos, and Magazines

  • The IIUG forums at /forums/technical.php
  • Informix Marketing channel on YouTube http://www.youtube.com/user/informixmarketing?feature=results_main
  • IBM DATABASE MAGAZINE at http://www.ibmdatabasemag.com
  • Credentials, the IBM Certification Newsletter at http://www-03.ibm.com/certify/email/201307credentials.shtml
  • There is now an Informix group on LinkedIn. The group is called “Informix Supporter”, so anyone loving Informix can join, from current IBM employees, former Informix employees, to users. It will also be a good occasion to get in touch with others or long-time-no-seen friends. If you fancy showing the Informix logo on your profile, join. To join, simply go to: http://www.linkedin.com/e/gis/25049/5E4B2048E558

Closing and Credits

The International Informix Users Group (IIUG) is an organization designed to enhance communications between its worldwide user community and IBM. The IIUG’s membership database now exceeds 25,000 entries and enjoys the support and commitment of IBM’s Information Management division. Key programs include local user groups and special interest groups, which we promote and assist from launch through growth.

Sources: IIUG Board of Directors

IBM Corp.

Editor: Gary Ben-Israel

For comments, please send an email to gary@iiug.org

Categorized as Insider

By Vicente Salvador

Board member since 2014, a user since 1989 and Informix fan. I'am software architect which allow me to combine technical and business skills.