IIUG Insider (Issue #62) August 2005

Highlights: IIUG Survey, IDS Training, Chat wit the lab, Calendar

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. The IIUG Survey
  3. The 6 Informix questions and interview with Bruce Weed
  4. IDS V10 Migration Guide
  5. Chat with the Lab
  6. Conference Corner
  7. New Red Books
  8. Gillani Offering free FourGen CASE Tools for 4GL Programmers
  9. Calendar of events
  10. A special note to IIUG members
  11. Useful links
  12. Closing and credits


August has been a tough month. Not for the IIUG just for me personally. Between leaving my old apartment and moving to my new one I have spent two exhausting weeks in limbo. I hardly had access to the Internet and very little time for the Insider. The result is a much slimmer issue. I am leaving it to your judgment if this is good or bad. I hope to be back on track for the September issue. I hope you have noticed the positive change in IBM’s attitude towards Informix. In our effort to help we are conducting a survey for IBM. We will NOT pass your personal data to IBM so please spare a few minutes of your time and take it. We would love to have some Informix success stories as well. If you would like to share them you can send them to me or to Carolyn Woods the IBM liaison to the IIUG Board of Directors at woodsc@us.ibm.com.

My email address is still: gary@iiug.org

Gary Ben-Israel
IIUG Insider Editor
IIUG Board of Directors

The IIUG Survey

The IIUG would like to ask your valuable input in a survey we are conducting. The survey will ask you about your company’s current dealings with IBM, database plans, and your perceptions about the future of Informix. This survey will be used by IBM to better understand and react to the needs of its dedicated Informix community.

Your information will be shared with IBM on a summarized basis — no personal information will be provided.

Please take a moment now to complete the survey; it will only be online for a limited time. It can be found at:


Thank you!

Privacy notice – what we do with the results

After the survey is closed, we will collect the results and provide them to IBM on a summarized basis – no individual names will be associated with any response. If you provide additional comments, they will be provided anonymously to IBM together with other user comments.

The 6 Informix questions and interview with Bruce Weed

Here are the questions I’ve heard hundreds of times since IBM bought Informix in July of 2001:

“Is IBM discontinuing Informix?”
“Is IBM is going to force Informix users to migrate to DB2?”
“Will Informix be around in 5 years? Do I need to move to another database now?”
“DB2 is a mainframe-only database, isn’t it?”
“Why doesn’t IBM market Informix?”
“What has IBM done for me – the Informix user – lately?”

They are indeed valid concerns – the kind of questions for which CIOs and CEOs need clear, concise answers. In this article, which includes an interview with Bruce Weed, Program Director for Informix Marketing, I’ll give you the answers.

Opinions or Facts?

My involvement with the International Informix Users Group (http://www.iiug.org) since 1997 has kept me keenly tuned in to both the user and the company side of the Informix product picture. In addition, one of the two major areas of focus for my company is the sale and support of Informix products so I am very much committed and invested in its future. While some have called me an eternal optimist I do need to make very important decisions about the future; this article is based on everything I know right now.

I also believe I can back everything up with empirical evidence: The opinions I express here are based on hundreds of discussions with IBM and users as well as a review of current product roadmaps and releases. I constantly monitor the future of Informix products and I believe everything here is accurate at this point in time.

But, I haven’t spoken to everyone or heard everything and I’d love to hear what you think! I’m not as connected with the users overseas and would like to hear those experiences as well. To share your experiences, please contact me at ron@iiug.org; I’ll publish a summary of feedback in next month’s IIUG Insider.

Is IBM discontinuing Informix?

This is the question that has been troubling IT decision-makers since IBM’s acquisition of the Informix product line. Unfortunately, this question has been very much fueled by IBM’s database competitors in an attempt to win Informix users.

It is very true that during the initial year or so of the transition there was a lot of confusion and uncertainty about the Informix product line. However, IBM has listened to the feedback of the IIUG and its extremely dedicated Informix community, delivering several releases of Informix Dynamic Server, XPS, and Red Brick. An excellent example is the current release of IDS 10, a major version upgrade with a large number of features. In addition, the next several product releases are scheduled through at least 2009. These releases are not just bug-fixes: They will include a number of features and enhancements. In addition, there is no end-of-life scheduled for Informix-SE, OnLine Extended Edition, and XPS, while IDS 7 support has been extended to 2009.

The reality is that IBM is one of the largest software companies in the world and they will support their customers as much as possible. It doesn’t make business sense to force users to migrate their deeply-embedded database solutions away from the Informix platform they trust. One of the quotes I’ve heard numerous times from Janet Perna, General Manager of the IBM Information Management division, is that “Informix users will have support as long as they need it.” Based on the release schedules and several discussions with IBM, I believe this to be entirely true.

Is IBM is going to force Informix users to migrate to DB2?

During the first two years of the transition, IBM’s direction was to support Informix users indefinitely while enhancing DB2 so that it would be an easy transition for Informix users. Also, we have heard that the message provided to the IBM sales force was that customers should strongly consider migrating to DB2. Neither of these strategies worked, and based on the IDS product announcements and repositioning of IDS as IBM’s embedded database of choice (see the interview with Bruce Weed for details), it appears that IBM has indeed listened to the desires of its customer base.

The current positioning allows customers to migrate to DB2 if they choose. Outside of that, customers are free to stay on their product of choice. To determine your company’s options, I suggest you contact an IBM representative or an IBM Business Partner that works with and understands Informix products.

Something that’s really impressed me lately is that IBM executives are mentioning Informix a lot in their data-related presentations. In fact, IBM encourages users to use IDS as the embedded database of choice for ISV applications, hardware devices, and more. I most recently heard these messages at the IDUG conference in May 2005 from Janet Perna, General Manager of Information Management, and Bob Picciano, Vice President of Database Servers.

One exception is that IDS 7 support will end in 2009, which is an extension of the original date of 2006. I believe this is reasonable because IDS 9 and 10 are extensions of IDS 7 and they have received numerous enhancements. The newer products also have a very large development team and are among the flagship products of the IBM Information Management brand. lf my company built software products, I would probably do the same thing: It’s very hard to support two or more major versions of the same product (IDS 7, IDS 9, IDS 10).

Will Informix be around in 5 years? Do I need to move to another database now?

Yes, IDS 10 and subsequent versions will be around, and no, you only need to move to another DBMS if it makes business sense (see “Find Out More” at the end of this article). IBM has laid out a very clear plan for Informix users and has documented it in several places on the Informix Web site. These plans include several major releases of the database products like Red Brick, UniVerse and UniData (a.k.a. U2), Informix Dynamic Server v10, and XPS. Other plans include maintenance releases of other products like Informix-SE, OnLine Extended Server, Informix-4GL, and XPS.

Of course it is true that not all software vendors will continue to support IDS 10 and other Informix versions. This is in fact one of the frustrations I’ve heard most often from Informix users. IBM is working aggressively to maintain this support (see the interview below) but the reality is that not all vendors will support the product lines indefinitely. In these cases, IBM is working to make it a very viable option for Informix users to migrate to DB2 UDB, and in some cases there is no charge for this service (see comments on SAP below).

(Before you send me a series of email flames, yes, I do know that this migration to a new DBMS can sometimes become very difficult and extremely time-consuming. My belief if that this would be the case for a migration to any new DMBS. It does appear that IBM is working to build many of the IDS features into DB2 and greatly simplify the migration, as Bruce Weed tells me in the interview.)

DB2 is a mainframe-only database, isn’t it?

Many customers I’ve encountered seem apprehensive about moving to DB2 because of the proverbial perception that DB2 is a mainframe-only database. Until about 2 years ago this was my perception as well. This is definitely not the case: when Janet Perna became General Manager of the newly-formed data management software division of IBM in 1996 one of her first objectives was to establish DB2’s presence in the distributed world, which includes several flavors of Linux, UNIX and Windows (LUW). The products include some very impressive GUI management tools (which most Informix users would love to see in their products) and a number of Web and security features. IBM’s goal is to continue to share best-of-breed technologies between Informix and DB2 UDB.

Why doesn’t IBM market Informix?

Actually this question takes us way back in time – to the pre-IBM days of Informix. At that time the question was “Why doesn’t Informix market Informix?”! It is indeed true that the early Informix marketing – or lack thereof – greatly helped Oracle establish itself as the UNIX market leader at that time, even though Informix seemed to be clearly ahead in technology (something I believe to be very true today as well). Informix was indeed the inventor of – at least one of the major contributors to – relational database systems on UNIX in the early 80’s, yet Oracle managed to gain enormous market share while Informix’s technology flourished.

IBM’s position on the marketing of the Informix products has been a sore spot with its users for as long as I can remember. The official position is that IBM simply doesn’t do much product-level marketing and Informix is no exception. This has changed a bit. While IBM isn’t necessarily launching massive Informix ad campaigns, they are making many efforts via ads and magazine articles to emphasize the fact that the product is still viable and will be around for a long time. Bruce discusses this in detail in the interview below.

This perceived lack of marketing has been one of my “hot buttons” over the last 3 years. The disturbing thing is that a lot of users and decision-makers say this proves that Informix is “going away.” Based on the facts, I simply don’t see how this theory has any credibility. I find myself asking these questions about this misconception:

  • If IBM has made all of these investments and long-term commitments to Informix, how are they killing it?
  • If IBM generally doesn’t follow a brand marketing strategy for products, why would it be different for Informix? You won’t see many DB2 ads – does that mean they’re killing DB2 as well?
  • Finally, do you see every technology marketed aggressively that your company has purchased?

You may not agree with IBM’s marketing strategy for Informix, but it certainly doesn’t mean they are killing the product!

What has IBM done for me, the Informix user, lately?

This statement has also been one of my hot buttons for the last year. IBM has done a LOT for the Informix user! Here are some examples that are documented on various portions of the Informix Web site:

  • A number of product roadmaps for Informix products
  • A major version release of IDS (version 10)
  • Interoperability between IDS and many other IBM products
  • A monthly “Chat with Labs” technical session
  • More support for Informix user groups
  • IDS 7 support through 2009
  • IDS is now considered the embedded IBM database for apps
  • An e-book for Informix users
  • The IBM sales force has been given a push to reach out to Informix users
  • Mark Scranton and other IBMers have been hired in a much more proactive user group role, providing an IBM-funded roadshow to dozens of user groups worldwide

These are just the things I remember. Part of the problem might be that users are simply not aware of these programs. Unless this information is proactively pushed to the users or you don’t see them on the Informix or IIUG Web site, it would be impossible to know about them. To get a better feel for these things, I suggest you use IIUG.org, the IIUG Insider, and http://www.ibm.com/informix (or http://www.informix.com) . I summarized these and other links in the “Find Out More” section at the end of this article.

The Interview with Bruce Weed

Following is an interview with Bruce Weed, Program Director for Informix Marketing. I asked him about all of the issues described previously in this article, and other topics as well. I appreciated his candor and the time he spent with me.

Flannery: What is your role within the IBM Information Management software group. (This group includes DB2, business intelligence, content management, and a number of other data-related products. It’s one of five software groups within IBM that include Tivoli, Lotus, Websphere, and Rational.)
Weed: My title is Program Director and my role is the Informix Business Leader. I focus on both product management as well as product marketing. I work closely with both the development teams as well as the sales teams.
Flannery: I’ve noticed a huge increase in the attention and marketing that IBM has given Informix over the last six months. For example: the major IDS 10 release; an extension of IDS 7 support through 2009; e-books and online product information; and the roadmap. This is great for the user community! What’s behind all this?
Weed: Janet Perna, General Manager of IBM’s Information Management division, has made a serious commitment to the Informix product lines. As a result, IBM has positioned Informix in several key target areas. This is an integral part of our portfolio, which now has Informix targeted towards specific markets like OLTP, small and medium business (SMB) as well as traditional Informix strongholds like telco, healthcare, retail, government, hospitality and finance. Also, IBM is positioning IDS as the embedded database of choice for OEM applications, hardware devices, and other third-party products that require an embedded database. The product is extremely stable and already included in a large number of services you frequently use.
Flannery: What caused this sudden interest? Why didn’t this happen sooner?
Weed: It is part of an overall repositioning of the market space for the Informix product line. We want to make sure we are being responsive to our dedicated Informix client base. We are committed to IDS as a key part of our over all information management portfolio.
Flannery: Along those same lines, what can we expect in the next 6-12 months?
Weed: Partners and customers can expect to see InfoBahn events worldwide launching IDS V10 and IDS Express through the end of the year, Chat with Labs teleconferences, and continued enhanced support for local user groups. For example, we have funded a “world tour” that brings Mark Scranton and other well-known IBM technologists to a large number of user groups around the world, providing technical “deep dives” for IDS 10, all funded by IBM.

IBM also provided support that made Informix an integral part of the IDUG conference in Denver from May 22-26. The WatchIT electronic communication is also very popular [see thesoftwareinstitute.org].

Essentially, we’re trying to continue what the users have found very successful and we’re beefing up areas based on additional user needs. We will continue to support and show attention to the user community and we greatly value all of the input that the IIUG has provided from its users.

Flannery: Many users have complained over the last few years about IBM’s lack of marketing the Informix product lines. What are your plans for Informix marketing and ads?
Weed: 2004 was really a launch-pad for 2005. We will start to include more direct marketing to customers and partners. This marketing will be targeted at small and medium business (SMB) for technical and line of business users [upper management]. The marketing will focus on ease of administration, stability, and scalability – the “no-fuss” philosophy. We have included Informix in corporate ads launched at the end of 2004 and that continue in 2005.

We’ll also seek more interaction with the press and analysts. This strategy will create a better understanding about how IBM will be continuing to support and enhance Informix products.

Flannery: We’ve been told that IBM will be presenting Informix as THE embedded database solution in the IBM database family. Is this correct? Can you tell us what types of products you had in mind?
Weed: Yes, that is correct. We have four areas in which we position the Informix products: 1) OLTP. This has been and will continue to be a sweet spot for Informix Dynamic Server. Informix is the high-availability OLTP engine of choice for many global businesses, organizations and even governments. 2) Small & Medium Business (SMB). IBM is making a strong drive to provide the right products for the SMB market. Informix really is a great solution for SMB customers: It’s low maintenance, extremely reliable, easy to maintain, and well-priced to help these customers. 3) OEM and embedded. We’ll increase Informix support for mobile devices in DB2 Everyplace. Cloudscape will continue to be the open source solution for Eclipse and Java. U2 provides multi-value applications for specific vertical markets. IDS is more of the industrial strength embedded for higher-end switches and devices. Also with ISVs that embed the IDS into their software products. We’re looking at some new programs and initiatives that will further embed Informix into applications and devices. We’ll have more details soon. Informix is already embedded in many services that you use every day including 911 call services, retail, hotel reservation systems, paying for gas, and a lot more. 4) Key Industry Verticals like telephone companies for embedded devices (routers, etc.) and retail point-of-sale databases
Flannery: What are your plans to promote continued IDS support with ISV vendors, like Baan and others?
Weed: IBM is aggressively engaging its ISV partners. We are focused on new ways to communicate with this partner set. We are leveraging webcasts, Infobahns, forums, as well as other methods to reach out. I want to make sure that ISVs understand the strategy around Informix and the growth we have been seeing in 2005. Informix is the place to be.
Flannery: I know that the issue of a “forced migration” to DB2 has been mentioned and feared by a lot of users. This is also constantly being mentioned by IBM’s competitors as a form of FUD [fear, uncertainty, doubt] to convince users that this is true. I personally know that IBM does NOT force migration and gives the users the option to stay on IDS if they want. Will IBM continue to keep the option of staying on IDS 9 and 10 available to current users?
Weed: Actually, IBM is encouraging its customers to stay on Informix. Ultimately customers can choose to run DB2 in addition to or as a replacement for Informix if the situation warrants it (e.g., an ISV that no longer supports IDS). The message is to migrate only if it’s warranted for your business.
Flannery: What about the FUD being spread by other vendors such as IBM’s biggest competitor in the UNIX space (“O”) and the Windows company?
Weed: Much of our upcoming marketing will address these inaccuracies. It is very clear from all the things we’ve done for Informix [described throughout this article] that IBM has made a strong, long-term commitment.
Flannery: What are the benefits for users to move to DB2? Will most IDS features be placed in future versions of DB2?
Weed: We are leveraging the technology of both products to make each other better. For example, Unicode in IDS 9.4 came from DB2; likewise, high availability data replication in DB2 8.2 (“Stinger”) came from IDS. There is a 2-way cross-sharing of technology between the products. We are aggressively continuing to develop both products. A good analogy would be with some of the US automakers that have similar products, such as Pontiac and Buick – they use many shared parts and underlying architecture is very similar. Customers use the one they like the best.
Flannery: Please tell me about IDS 10’s features.
Weed: IDS 10 is even faster than IDS 9.4, which was already the fastest version of Informix – about 15% faster than IDS 7.31. Some of the features include online index rebuilds; rolling application upgrades, which allow you to stay online while upgrading applications; column-level encryption; compliance for Basel 2, SOX, and HIPAA; manageability – installation time is much simplified with new installer; and single-user mode for administration. We describe all of these features in detail on the Informix homepage.
Flannery: What are some major reasons that IDS 7 users would want to migrate to IDS 10?
Weed: Security, performance, Internet/Java, scalability. Server consolidation – for example, zSeries mainframe running IDS 10 Linux. IDS 10 also gives you the option to move to new hardware, perhaps running Linux on xSeries or pSeries. Overall, it provides cost savings, higher performance and functionality with today’s standards.
Flannery: Does IBM plan to continue support for the IIUG and its activities? What value does IIUG bring to the table for IBM?
Weed: IBM feels that IIUG brings tremendous value. They help us understand the wants and needs of our customers and partners. The IIUG constantly works with the user community and their insight is invaluable. IBM will continue to support the IIUG’s activities and user conferences. Carolyn Woods is an IIUG board member that reports directly to me. Mark Scranton has been funded to travel to dozens of cities around the world. These investments and others really show IBM’s commitment.
Flannery: Can you describe the integration of IDS with other IBM products, including WebsSphere, Rational, Content Manager, Information Integrator, and Tivoli?
Weed: Some examples are WebsSphere MQ, WebSphere Studio, and Rational EGL. Tivoli provides monitoring and data protection. Rational Application Developer for WebSphere provides a possible migration path for 4GL users. Content Manager provides IDS connections via Context Media. We also provide Lotus Enterprise Integration and Workplace compatibility. We’re working on more integrations as we move forward, including Informix support for the Alphablox OLAP development environment, Informix support from DB2 tools, and connectivity to DB2 Everyplace.
Flannery: Any closing comments?
Weed: IBM is looking forward to continue meeting the needs of our customers and business partners. We want to delight our Informix users. Our goal is to continue to grow our customer base and provide increased visibility around the Informix product lines.
Flannery’s Conclusions and Your Feedback

There you have it. I believe that from everything I’ve seen happening in the Informix world over the last year and Bruce and Janet’s comments, Informix will be around for a long time and the users have many choices. I know that not everyone will agree with me and I’ll undoubtedly be “flamed” by some users worldwide, so please send me your thoughts! You can reach me ron@iiug.org. I’ll publish a follow-up in next month’s IIUG Insider.

Find Out More

There is a wealth of resources and information about Informix. The links below should bear out many of the facts stated in this article and interview.

The IIUG’s homepage, including the latest news and various links:
Informix homepage:
http://www.informix.com or
Informix news:
Informix portfolio update:
Informix e-book:
The IIUG Insider, including plenty of news and technical and product-related articles about Informix:
Real world experiences with Informix and other IBM products:

IDS V10 Migration Guide

The IBM Informix Dynamic Server Version 10.0 Migration Guide describes the migration procedures to convert or upgrade to Version 10.0 of IBM Informix Dynamic Server, revert to earlier versions, and move data between databases, database servers on the same or different operating systems, and computers. This manual also contains information on how to use the dbexport, dbimport, dbload, dbschema, onload, and onunload data-migration utilities and the LOAD and UNLOAD SQL statements.conversion (upgrading) to a later version of a database server, reversion to an earlier version of a database server, and movement of data between databases, database servers on the same operating system, database servers on different operating systems, and different kinds of database servers. Conversion or reversion often involves changing connectivity information in the sqlhosts file or registry key, host environment variables, configuration parameters, and other database server features.

To read the complete contents of the guide:

  1. Go to the Informix Information Center at http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp
  2. Select Migration Guide from the ‘Administering’ or ‘Complete IDS Library’ headers

Carolyn Woods
Segment Lead, Database Technology Awareness
IBM Information Management Software
Ph: 602-357-4398; TL 273-0096

Chat with the Lab

Ensuring Integrity of Distributed Transactions using 2-Phase Commit

Wednesday, September 7, 2005
11 AM Eastern Standard Time – 90 minutes

Informix Dynamic Server has supported two-phase commit for some time, with v10.0, we now have improved and more extensive capabilities with the new MQ Datablade (TM) now commercially available. This provides more functionality and tighter integration with IBM’s MQ products, known for reliable message delivery between virtually all types of applications on a wide variety of platforms. Our speakers will be:

Jerry Keesee, Director of the Informix Lab and
Keshava Murthy, IDS Architect.

You may RSVP to: https://ww4.premconf.com/webrsvp/register?conf_id=3064360

Conference Corner

The 2005 IDUG / IIUG Conference in Denver was a complete success, but get ready, the IIUG Board of Directors and the IDUG Board of Directors have decided to continue forward towards joint conferences.

IDUG 2006 – North America
In conjunction with the International Informix Users Group (IIUG)
May 7 – 11, 2006 – – Tampa Convention Center – – Tampa, Florida


This is your opportunity to share your Informix experience and expertise with an audience of your peers at the premier user event dedicated to IBM’s industry-leading database engine, Informix.

With this announcement being made, a Call For Papers for 2006 in Tampa, Florida May 7 – 11, 2006 is now open. All initial presentation proposals must be submitted by September 16, 2006!!

All Informix content will be under the complete direction of the IIUG Conference Planning Committee . If you are interested in speaking, please visit /conf for guidelines and links to submit your presentation abstract for the 2006 Tampa Conference.

You will receive one complimentary IDUG 2006 – North America conference registration, if your presentation abstract is selected to be delivered at the conference.


IDUG is soliciting presentation abstracts, which delve into the details of implementation, migrating to a new release, or maximizing performance from any member of the Informix product family.* In recognition of the complex requirements of today’s database implementations, IIUG is also soliciting presentation abstracts relating to tools and utilities solutions complementary to the Informix product family.

All presentations must be strongly technical in nature, cannot contain marketing themes, and must compliment the Informix product family:

*The Informix Product Family includes Informix Dynamic Server (IDS), Informix 4GL, Informix SQL, Informix ESQL/C, Standard Engine (SE), Online (5.X), XPS, EGL, RedBrick and other related Informix products.


IIUG strives to achieve a balanced conference program of business solutions relevant to today’s IT environment and usage of Informix on one or more platforms (e.g., Windows, Linux, UNIX). Past presentation topics have included:

  • Experiences relating to the implementation of, or migration to, new releases of Informix
  • Tips on managing or improving the performance of a Informix environment
  • Tips on managing or improving the availability of a Informix environment
  • New and creative implementation and use of Informix features
  • Clever ways Application Programmers have used Informix features or utilities
  • Experiences using Informix for e-business applications
  • Experiences using Informix for ERP applications
  • Experiences using Informix for data warehousing and business intelligence applications
  • Experiences using IDS’s object-relational functionality
  • Instances where your company has taken Informix to the limit and lived to tell about it
  • Experiences with information integration of Informix applications
  • Informix User Experiences
  • Information Integration
  • Web Services

If your presentation is selected to be delivered at IDUG 2006 – North America, you will receive one complimentary conference registration. Dual presenters are eligible for one free conference registration and a second registration at a reduced rate. The conference registration fee includes access to all conference activities, scheduled meals and social functions, program materials, conference proceedings, and a one-year IDUG membership.

Additionally, all presentations delivered by users are eligible for “The Best User Presentation” award. “The Best User Presentation” award is based exclusively on the evaluation of conference attendees. If your presentation is selected as “Best User Presentation,” IDUG will send you on an all expense paid trip to deliver your presentation at another IDUG conference.


September 16, 2005 – Abstracts due to IDUG Headquarters. IDUG will confirm receipt of your abstract(s) submission(s) via e-mail.

Week of November 4, 2005 – Speakers will be selected and notified via e-mail/telephone.

February 20, 2006 – Draft presentation due to IDUG Headquarters.

March 16, 2006 – Final presentation due to IDUG Headquarters.


Please visit /conf for details.

See what other IIUG members said about the 2005 IDUG Conference in Denver at /news/insider/insider_may05.html#2.

New Red Books

REDBOOK HOT OFF THE PRESS: Transitioning: Informix 4GL to Enterprise Generation Language (EGL) SG24-6673

URL: http://www.redbooks.ibm.com/abstracts/sg246673.html?Open

Informix 4GL to EGL Conversion Utility
The Informix 4GL to EGL Conversion Utility was announced in March, 2005. The Conversion Utility is a pluggable iFeature available with Rational Web Developer (RWD), Rational Application Developer (RAD) and Rational Systems Architect (RSA) products.

The 4GL to EGL Conversion Utility allows Informix customers to upgrade their 4GL application development environment to the Rational Software Development platform and, more specifically, transition to the Rational Enterprise Generation Language.

What is Enterprise Generation Language (EGL)?
EGL is a programming language that lets you write full-function applications quickly by freeing you to focus on the business problem rather than on complex software technologies. The details of Java, J2EE and other complex middleware APIs are hidden from you, so you can deliver enterprise data to browsers, portals and business integration solutions even if you have minimal experience with new technologies.

Transitioning 4GL to EGL REDBOOK
This new Redbook will help your customers update their Informix 4GL development environment to EGL, which is an integral part of IBM’s strategic set of Rational Development tools. EGL offers the right balance of simplicity, power and versatility which makes it easier to build robust web applications as well as helping to solve business problems by targeting “business oriented” developers and enabling them to extend their reach to more modern development tools.

Informix 4GL developers who are unfamiliar with Java can use EGL to quickly build data-driven Web applications and business logic. They can then write and debug their applications in EGL, and the Java code will be generated for them. So they can then build dynamic Web applications without having to learn the Java language. This provides significant advantages, enabling clients to minimize application development time and resource requirements.

For more information access the following links:

ANOTHER NEW REDBOOK! Database Strategies: Using Informix XPS and DB2 Universal Database (SG24-6437)

URL: http://www.redbooks.ibm.com/abstracts/sg246437.html?Open

The acquisition of Informix by IBM has provided the opportunity for Informix customers to consider new alternatives to further enrich their data management systems infrastructure. They can now more easily take advantage of available products, services, and capabilities as they grow and change.

This IBM Redbook focuses on:

  • Strategies, techniques, capabilities, and considerations for using Informix Extended Parallel Server (XPS) and DB2 Universal Database (UDB).
  • Detailed discussions and data to give a good understanding of the two products, their capabilities, and their similarities.
  • How XPS customers can choose to adopt a database strategy of coexistence or consider transitioning to DB2 UDB.
  • The features and functionality of each DBMS for a better understanding, in areas such as architecture, partitioning techniques, SQL considerations, configuration, indexing, data types, DML, and DDL.
  • Products and tools to complement these database management systems.

With this information, customers can better decide which products satisfy their particular requirements, and better plan on how to achieve their objectives as they develop their database management system strategy. They will be better positioned to make informed decisions that can give them the best return on their DBMS investment.

Gillani Offering free FourGen CASE Tools for 4GL Programmers

Gillani’s FourGen CASE Tools offer Hi-Speed Rapid Application Development environment for Informix 4GL programmers.

  • Slash development time from months to days
  • Dramatically increase productivity without adding staff
  • Free-up precious development time for vital projects
  • Do it all at a cost that is amazingly low

Currently, Gillani is offering Free Two-User license of FourGen CASE Tools, when you renew your 4GL and IDS annual maintenance through Gillani. Offer is good through December 2005. Gillani is also an IBM reseller of Informix product.

For more information, visit http://www.gillani.com or call 1-877-424-8500

Calendar of events

September – 2005
Date Event Location
12 IBM Data Management Technical Conference Orlando, Florida – Register now! http://www.ibm.com/training/us/conf/db2
20 Informix Infobahn Barcelona, Spain
21 Informix Infobahn Madrid, Spain
December – 2005
Date Event Location
8 Informix Forum Atlanta, Georgia

A special note to IIUG members

A special note to IIUG Members from Steve W. Martin, Author of The Real Story of Informix Software and Phil White (http://www.storyofinformix.com):

When I joined Informix Software in 1991, I had no idea of the tremendous highs and lows I would experience over the following six years. I witnessed a company grow from just over a hundred million dollars to a billion dollars in sales, from hundreds of employees to almost five thousand, and I saw a two-dollar stock rise, split, and increase to over ninety dollars. The times were exciting and the pace was frenetic.

Along with the accomplishments during my tenure at Informix, I also remember a company that launched products that didn’t work quite as advertised, squandered half a billion dollars on failed business strategies, and participated in a merger without winners. Worse yet, I witnessed Informix Software’s complete collapse–culturally, ethically, and financially.

However, only through the passage of time have I been able to put these events into proper perspective. I have included them in my new book titled, The Real Story of Informix Software and Phil White: Lessons in Business and Leadership for the Executive Team. While the book won’t be available in bookstores until October, you can purchase advance copies on my web site at http://www.storyofinformix.com. Through October, IIUG members will receive a $4 discount if they specify “IIUG MEMBER” in the inscription field on the order entry form.

Informix Software has played an important role in many people’s lives; investors, employees, and most of all, customers. In fact, the highlight of my time at Informix was working with customers. The people who bought Informix Software’s products were different. They weren’t awestruck by Oracle and its emperor Larry Ellison. They weren’t enamored by Sybase’s elitism. They were straight-shooters in search of the truth. And, the plain truth was that the Informix database was the best.

Wishing you continued success,

Steve W. Martin

Useful links

In response to your input, we have created a page on the IIUG web site containing all the links we used to include. Please find it at: /quicklinks.html

Closing and credits

The International Informix Users Group (IIUG) is an organization designed to enhance communications between its worldwide user community and IBM. 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.

Sources: IIUG Board of Directors
IBM Corp.
Editors: Gary Ben-Israel
Stuart Litel
Jean Georges Perrin

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.