planetIDS (via FeedRinse)
Informix on Campus - back online
I am happy to announce that the migration of the Informix on Campus wiki is complete and the site is back online! The URL has changed and so please update your bookmarks - https://www.ibm.com/developerworks/connect/informixoncampus. In a week or two, all the major search engines should have this wiki indexed.
Notes from Lecture on 'The Thinking Eye' by Edward Tufte, the 'Leonardo da Vinci of Data
[All errors are mine. The views for information only. These are views of Edward Tufte, not IBM].
Organized by The Hive
IBM Informix Request for Enhancement Tool
I have no idea how IBM decides what new features to add to Informix, but I do know that we can now be part of the discussion by using the new Request for Enhancement tool (RFE Tool). I took this for a spin today and I must admit this is a pretty interesting thing that you should check out. Not only can you submit your own requests for new features, you can view what everyone else has suggested and vote for what you want to have added.
Service Interruption
For many members of the Informix community, this is the busiest and the fun part of the year! Yes, I am referring to our annual IIUG Conference about to open on Sunday, April 21st in San Diego, California. I hope to see many familiar and new faces at the conference this year.
Accelerating dynamic SQL to Informix warehouse accelerator
Once you deploy and load the data mart on to Informix Warehouse Accelerator, all your dynamic queries will get accelerated. The phrase "dynamic queries" needs little bit of explanation. Dynamic queries include the following:
IIUG-2013: Talks on Informix 12.1 warehouse features.
At IIUG, on Monday and Tuesday, we'll have two sessions on What's New in IBM Informix 12.10? giving overview of 12.10 features as well as talking about other sessions in various domains. In the remote case, you cannot attend that talk :-), here is the IIUG session grid with my recommendations for
What's the hottest new feature in Informix 12.10?
In the next edition of IBM Data Mag (http://ibmdatamag.com/), Lester Knutsen gives us a quick overview of the new Informix version 12.10 Grid Query feature. This, I think, is the hot new feature! Lester refers the feature back to a similar XPS feature that allowed one to distribute a database across many servers and issue queries to the entire group of servers treating the entire distributed data set as a single database. "Can't I do that with any RDBMS that supports distrib
12.10 install issue on HP-UX / Problema na instalação de 12.10 em HP-UX
This article is written in English and Portuguese (full article here)
Este artigo está escrito em Inglês e Português (artigo completo aqui)
English version:
Very quick post to report a small issue and it's solution while installing the latest Informix version (12.10) on HP-UX (11.31 - Itanium).
When You Need to Store a String of Numbers in a CHAR Column
Sometimes you have to store a string of numbers in a CHAR column. Probably because the string of digits represents an account number or something similar and storing as an INTEGER or BIGINT doesn't really make sense. The account number could have leading zeros that would be lost if stored as an integer. Parts of the account number could store special information, like positions 2,3 and 4 identify what department an account belongs to and it might be useful to be able to select digit_string[2,4]. There are plenty of reasons to store numerical data in a string.
Edition changes / Mudanças nas edições
This article is written in English and Portuguese
Este artigo está escrito em Inglês e Português
English version:
One of the changes in version 12.10 refers to the editions. In each version there are several editions which try to address different markets and usage scenarios. I know for experience that customers don't like to see changes in editions. But I also am used to see a lot of confusion in the market about which editions exist, and the limits in each one.
Informix 12.10 Launch Web Cast for Reseller BPs
If you are an IBM Business Partner interested in reselling Informix, feel free to attend one of the two web casts below. These were recorded and a link is provided here and in PartnerWorld/Informix for replay. See Replay at: https://www-304.ibm.com/partnerworld/wps/servlet/mem/ContentHandler/W808871S66865T68
Prepared statements and the SQL statement cache
Recently I was asked whether I use the SQL statement cache. The answer was no but the more interesting question was why not. When I thought about the reasons why not most of them were out of date or boiled down to a lack of understanding of the finer details on my part.
New TimeSeries loader API
The Informix team has added a public version of a fast loading mechanism. It allows to load into existing TimeSeries that are defined as part of a container.
New TimeSeries loader API
The Informix team has added a public version of a fast loading mechanism. It allows to load into existing TimeSeries that are defined as part of a container.
OLAP Window Functions
This article is written in English and Portuguese
Este artigo está escrito em Inglês e Português
English version:
In this article I'll mention some new functionality in 12.1, but I'll use that to answer a recent question on IIUG mailing list. The question initially posted was about when did Informix update the index involved in a transaction. But after a few interactions with the original poster, it was clear what the problem was and it's a bit tricky:
Informix 12.10 is ready / Informix 12.10 está pronto
This article is written in English and Portuguese
Este artigo está escrito em Inglês e Português
English version:
As we should all know by now, IBM announced the next major Informix version last Tuesday, March 26 with a webcast that is available for replay here.
