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.
Contents:
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
Table of Contents
Editorial
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
gary@iiug.org
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 |
Keywords
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 |
ACE Report Programing Language |
|
|
AWK |
AWK Programing Language |
|
| BISON | GNU Version of yacc | |
| C | C Programing Language | |
| C-ISAM | C functions for I-SAM files | |
| CPP | cpp – C Language Preprocessor | |
| DBA |
Database Administration Utilities |
|
|
ESQLC |
ESQL/C Environment or ESQL/C Source |
|
|
I4GL |
Informix-4GL Environment or Informix-4GL Source |
|
|
ISQL |
Informix-SQL Environment |
|
|
ISQLPERL |
Perl Extension to Interface with Informix |
|
|
JAVA |
Java Environment or Java Source |
|
|
KSH |
Korn Shell |
|
|
LEX |
lex – Lexical Analysis Program Generator |
|
|
LSDW |
Large Scale Data Warehouse |
|
|
MISC |
Miscellaneous Routines and Utilities |
|
|
NEWERA |
New Era Environment or Source |
|
|
ORDBMS |
Object-Relational Database Extensibility, DataBlades |
|
|
PERL |
Perl Programming Language |
|
|
PHP |
PHP Web Programming Language |
|
|
SH |
Bourne Shell |
|
|
SPERFORM |
Informix Form Generation Utility |
|
|
SPL |
Stored Procedures |
|
|
SQL |
SQL Scripts or General SQL Tools |
|
|
VB |
Visual Basic |
|
|
YACC |
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
https://ibmanalytics.ideas.aha.io/?project=INFX&sort=popular
Please visit this site vote for your favorite enhancements or place a new request.
Added last month:
|
Topic |
Votes |
Status |
|
Automatic Statistics table exclusion list |
1 |
Need review |
|
Implement UUID keyword/function |
1 |
Need review |
|
Storing Large Objects in file system |
1 |
Need review |
Top 10
|
Topic |
Votes |
Status |
|
Backup from RSS or HDR Secondaries using ontape, onunload, onbar, dbexport |
75 |
Future consideration |
|
Obtain the query plan of a running query |
61 |
Future consideration |
|
SQL interface to obtain the temporary space usage (tables, hash, sorts…) |
56 |
Future consideration |
|
Backup Individual database, not entire instance |
48 |
Future consideration |
|
Informix should be able to change owner on tables and any other objects |
47 |
Future consideration |
|
Implement CREATE OR REPLACE option for stored procedures |
39 |
Future consideration |
|
New feature to have FORCE_DDL_EXEC functionality for all DDL changes |
30 |
Need review |
|
Ability to re-create views and procedures without dependent objects being dropped |
24 |
Future consideration |
|
Use of Adobe Flash in OAT is a security problem, please migrate to HTML5 |
23 |
Will not implement |
|
Need an onmode option to terminate orphaned, tightly coupled global transactions. Onmode -Z does not address this case |
23 |
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
https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.community.doc/community.htm
5.1 Informix Blogs and Wikis
Blogs and Wikis that have been updated during the last month
- Andrés Repossi https://andreserepossi.wixsite.com/hablemosinformix (In Spanish)
More Blogs and Wikis
- Art Kagel http://informix-myview.blogspot.co.il/
- Ben Thompson’s blog at: https://informixdba.wordpress.com/
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
