|End of Support Dates|
Highlights: Informix 2011 highlights
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.
The highlights of 2011 were increasing the Informix portfolio with the Informix Warehouse Accelerator and Genero, the IIUG conference, Continuing Support Offering for Informix versions 7.31, 9.4 and 10 and new packaging. For 2012 we are expecting a new Informix release, an exciting IIUG conference in San Diego and more Informix sales and Informix users. We hope the one day Informix will be ahead of Oracle for real, not just on Las Vegas taxi cabs.
I would like to wish you all a wonderful year.
A note from the IIUG president
Just to remind all my friends out there that the Early Bird Special Conference pricing expires on January 15, 2012. The current low price of $695 (USD) will go up (and remember IIUG members can get another $100 of to bring it down to an unheard of low $595 for the full conference price).
Informix 2011 highlights
The year as summarized by Insider highlights:
2012 IIUG Informix Conference Update
We have been overwhelmed by the quality and quantity of speaker submissions for the 2012 IIUG Conference. The submissions cover every facet of topics pertinent to Informix users and administrators, including new features like Time Series and the new IBM Genero product line, as well as tried and true "must have" topics like those involving maximizing your system performance while minimizing system downtime. Our speakers for this year's conference are the best our Informix community has to offer and include several new speakers.
The IIUG Conference committee worked through the fall to review all submitted presentations to select the very best sessions, hands-on-labs and tutorials for the 2012 Conference. The sessions we've chosen include interesting and relevant topics that can be used to reinforce your professional skills and keep current in today's changing market. Remember, the 2012 IIUG Conference is not "Just For DBAs" anymore: Bring your application developers too!
Please continue to review the conference website for regular updates at http://www.iiug.org/conf. The Conference website will be updated as speakers confirm their selection to include details of sessions, hands-on-labs and tutorials. The 2012 IIUG Conference will be our best conference to date.
To take advantage of the early bird registration price of $695, register for the Conference by January 15, 2012. Save an additional $100 if you are an IIUG member. If you are not currently an IIUG member and want to take advantage of the additional $100 savings, please go to http://www.iiug.org/iiug/join.html. There is no fee to become an IIUG member. Becoming a member will increase your Conference savings, and allows access to the Members Only section of the IIUG Website, where downloads of some of the latest IBM Informix products are available, as well as IIUG-only utilities written by DBAs for DBAs.
To register for the Conference or for additional information, go to:
A document that may help convince your supervisor or other management to allow you to attend the 2012 IIUG Conference can be found here:
This document provides information you can use to support your Conference attendance proposal. Remember, this is the best conference you will find for the money! We think you might find San Diego to be no more expensive to get to than Overland Park was. There is no need to rent a car in San Diego, as the airport is a cheap cab ride from the conference hotel. And many air routes to San Diego are no more expensive than to Kansas City; a surprising number we checked were cheaper!
See you at the Conference!
Web Site Help
Can you find everything you are looking for on the www.iiug.org website? I know it can be a challenge at times. The fact is, there is just SO MUCH out there it can be hard to organize. In an effort to make this less painful, a new HELP link has been added to the front page of the web site. When you click it, you will get an expanded tree of the menus under the tabs on the right side of the page. Hopefully this will help! Here are the details.
IIUG Insider - quick link to the current issues, with the ability to find past issues.
IIUG Hotspots - Links to commonly used items on the web site (basically the old web site arrangement).
IIUG.org Hot Spots:
Related User Communities:
Informix Links - These are all links to other website locations of interested in the following areas:
International - Tabs for information in languages besides English
IIUG RSS Feeds
Software Repository - These pages allow you to access the IIUG Software Repository and other Informix-related archives on the Net.
Product Offerings (was Informix Products) - This area shows you the current offerings and product lines from IBM.
Online Resources - This lists a number of tools , magazines and newsletters, and conference information.
Technical Library (was Document Library) - Tabs for each topic of interest and a collection of various information for that topic.
Books and RedBooks - a list of known books on Informix and a dynamically created link to every Redbook.
IIUG Banners - pictures you can download for presentations and use at Local User Group meetings.
Analyst Reports/Success Stories - links you can show your management that detail the success stories from various companies and include a few analyst reports related to Informix.
Technical Special interest Groups (SIGS) - Discussion groups technical issues or preferred languages.
Other Discussion - Discussion groups that are not sponsored by IIUG.
Events - List of upcoming Events from the calendar.
Webcasts/Chat w Lab - recorded Webcasts and Chat with the Labs.
IIUG TV - Videos about the Informix worlds.
IIUG Sponsors - a list of very special Informix using businesses that have sponsored the IIUG.
Business Directory - Businesses are invited to list themselves in our directory of Informix products
IIUG Press Partners - list of magazines publishing IIUG articles.
Local User Groups - List of every organized user group in various locales throughout the world.
Job Board - Hunting for a job, or wanted to post a job -this is the place.
Kate Tomchik, IIUG Board of Directors
Informix Chat with the Lab
While IBM Informix is the database software voted #1 in customer satisfaction, clients choose Informix because it is reliable, low cost, and hassle free. Century Software is an IBM solution provider that choose to build our Century Financials, Enterprise Class, ERP suite on Informix for its best-of-breed embeddability, and its performance. With one of the largest Informix user bases in the world, Century Financials is the most comprehensive Financial ERP solution designed and developed to utilize the power and functionality of the Informix relational database management system. Leveraging an IBM validated architecture, Century Financials is implemented in over 110 enterprises, with over 100,000 customers using IBM's Informix database every day.
Register for this event at https://events.webdialogs.com/register.php?id=230902b822&l=en-US
For questions about this event, contact the host at: email@example.com.
Informix is Going Back to Wild West: http://bit.ly/vxGYoy
Does Informix Genero support REST based web services? Read this Blogpost to get the details: http://ibm.co/rO1DnQ
IBM Informix Health Advisor Plug-in for OpenAdmin Tool (OAT): http://ibm.co/tbpSpj
A summary of the most popular IBM Informix Technical documents that you could refer to: http://ibm.co/uWLwQI
New Built-in SQL Functions
Informix is continuously working to make new SQL functions for compatibility and effortless application migration experience. Informix provides numerous built-in functions that you can use in queries to return data or perform operations on data. It recently introduced several new built-in SQL functions for string manipulation and trigonometric support. Let’s take a quick peek in these functions.
String Manipulation Functions
String manipulation functions return either a character string derived from an argument to the function, or an integer that describes a string argument.
Table 1: String Manipulation Functions
Trigonometric functions convert the units of angular measurement of a numeric expression argument from radians into degrees, or from degrees into radians.
Table 2: Trigonometric Functions
All the above functions were introduced in Informix version 11.50.xC3. Hhope you find a good use of them.
Informix blogs and things
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 Data Management division. Key programs include local user groups and special interest groups, which we promote and assist from launch through growth.
For comments, please send an email to firstname.lastname@example.org.