column length (collength)

Discussion:

(too old to reply)

t***@gmail.com

2013-01-23 21:21:25 UTC

we have a table named role with a field of create_date and it is
DATETIME YEAR TO FRACTION

when i run this:

select * from syscolumns where tabid = (select tabid from systables where tabname = 'role')

the collength returns as 4365

anyone know why or how Informix interprets this? the 4365 collength?

thanks
tom

Jason Harris

2013-01-23 23:42:51 UTC

Permalink

Hi Tom,

Check the syscolumns table in the system catalog tables section of the SQL Reference.

For datetime the calculation is:
(length * 256) + (first_qualifier * 16) + last_qualifier

For year to fraction(3) that is:
(17 * 256) + (0 * 16) + 13 = 4365

HTH,

Jason

t***@gmail.com

2013-01-24 12:35:07 UTC

Permalink

Thank you much

Art Kagel

2013-01-26 23:35:34 UTC

Permalink

The values for the parts of the qualifiers are found in the header file
datetime.h in $INFORMIXDIR/incl/esql along with macros to extract the
values.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.

Post by t***@gmail.com
Thank you much
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list

FRANK

2013-01-28 22:03:47 UTC

Permalink

Just make sure.
I have a column defined as,
ingest_dt datetime year to second not null ;
Its info in syscolumns shows,
colname ingest_dt
tabid 267
colno 7
coltype 266
collength 3594
colmin
colmax
extended_id 0
seclabelid 0
colattr 0
So, physically, the ingest_dt column might occupy 3594 bytes in disk for a
row?
I doubt this.
Thanks,
Frank

Post by Art Kagel
The values for the parts of the qualifiers are found in the header file
datetime.h in $INFORMIXDIR/incl/esql along with macros to extract the
values.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.

Post by t***@gmail.com
Thank you much
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list

_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list

Jack Parker

2013-01-28 22:09:08 UTC

Permalink

Something I wrote some time back.

create procedure collength(p_coltype smallint, p_collength smallint)
returning smallint

DEFINE i,j,k INTEGER;

IF p_coltype>255
THEN LET p_coltype=mod(p_coltype,256);
END IF;

IF p_coltype= 0 THEN return p_collength;
ELIF p_coltype= 1 THEN return p_collength;
ELIF p_coltype= 2 THEN return p_collength;
ELIF p_coltype= 3 THEN return p_collength;
ELIF p_coltype= 4 THEN return p_collength;
ELIF p_coltype= 5 THEN
let i=trunc(p_collength/256);
IF mod(i,2)=0
THEN
let j=(i+4)/2;
ELSE
let j=(i+3)/2;
END IF;
IF mod(j,2)=1
THEN
LET j=j-1;
END IF;
IF j>17 THEN
let j=17;
END IF;
RETURN j;
ELIF p_coltype= 6 THEN return p_collength;
ELIF p_coltype= 7 THEN return p_collength;
ELIF p_coltype= 8 THEN
let i=trunc(p_collength/256);
IF mod(i,2)=0
THEN
let j=(i+4)/2;
ELSE
let j=(i+3)/2;
END IF;
IF mod(j,2)=1
THEN
LET j=j-1;
END IF;
IF j>17 THEN
let j=17;
END IF;
RETURN j;
ELIF p_coltype= 9 THEN return p_collength;
ELIF p_coltype= 10 THEN RETURN MOD(p_collength,256);
ELIF p_coltype= 11 THEN return p_collength;
ELIF p_coltype= 12 THEN return p_collength;
ELIF p_coltype= 13 THEN return mod(p_collength,256);
ELIF p_coltype= 14 THEN RETURN MOD(p_collength,256);
ELIF p_coltype= 15 THEN return p_collength;
ELIF p_coltype= 16 THEN return mod(p_collength,256);
ELIF p_coltype= 17 THEN return p_collength;
ELIF p_coltype= 18 THEN return p_collength;
ELSE RETURN 0;
END IF;

END PROCEDURE;

Post by FRANK
Just make sure.
I have a column defined as,
ingest_dt datetime year to second not null ;
Its info in syscolumns shows,
colname ingest_dt
tabid 267
colno 7
coltype 266
collength 3594
colmin
colmax
extended_id 0
seclabelid 0
colattr 0
So, physically, the ingest_dt column might occupy 3594 bytes in disk for a row?
I doubt this.
Thanks,
Frank
The values for the parts of the qualifiers are found in the header file datetime.h in $INFORMIXDIR/incl/esql along with macros to extract the values.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
Thank you much
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list

Art Kagel

2013-01-29 00:27:49 UTC

Permalink

No. The collength value includes the starting and ending precision of the
datetime encoded in it as well as the length.

LENGTH = collength >> 8
StartPrec = (collength >>4) mod 16
EndPrec = (collength mod 16

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.

Post by t***@gmail.com
Thank you much
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list

_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list

Jonathan Leffler

2013-01-29 00:43:24 UTC

Permalink

3594 decimal is 0x0E0A (hex).

The 0E means the total length is 14 digits, which translates to (14/2 + 1)
= 8 bytes on disk. The second 0 indicates the start field is YEAR. The A
indicates the end field is SECOND. You have a DATETIME YEAR TO SECOND.

The encoding is slightly different, but closely related, for INTERVAL types.

If you've got ESQL/C and understand C, the datetime.h header will show
TU_YEAR = 0 and TU_SECOND = 10, which is where the last two hex digits come
from. The length is a modestly complex formula - see the TU_DTENCODE()
macro and relatives; TU_IENCODE for INTERVAL types.

Post by t***@gmail.com
Thank you much
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list

_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list

--
Jonathan Leffler <***@gmail.com> #include <disclaimer.h>
Guardian of DBD::Informix - v2013.0118 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."

FRANK

2013-01-29 02:30:43 UTC

Permalink

Thanks Jonathan, Art and Jack! Very good! Frank

On Mon, Jan 28, 2013 at 7:43 PM, Jonathan Leffler <

Post by Jonathan Leffler
3594 decimal is 0x0E0A (hex).
The 0E means the total length is 14 digits, which translates to (14/2 + 1)
= 8 bytes on disk. The second 0 indicates the start field is YEAR. The A
indicates the end field is SECOND. You have a DATETIME YEAR TO SECOND.
The encoding is slightly different, but closely related, for INTERVAL
types.
If you've got ESQL/C and understand C, the datetime.h header will show
TU_YEAR = 0 and TU_SECOND = 10, which is where the last two hex digits come
from. The length is a modestly complex formula - see the TU_DTENCODE()
macro and relatives; TU_IENCODE for INTERVAL types.

Post by t***@gmail.com
Thank you much
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list

_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list

--
Guardian of DBD::Informix - v2013.0118 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."

j***@chubb.com

2013-01-29 15:28:48 UTC

Permalink

Hi Guys!

Will IDS 11.70 be the last version of the product? This is making some
noise lately! Have you heard anything on the future of IDS? Is it going to
be any more development of IDS down the road. Please advise!

jp

Jack Parker

2013-01-29 15:44:53 UTC

Permalink

There is an EVP effort underway at this time for version 12.

j.

Post by j***@chubb.com
Hi Guys!
Will IDS 11.70 be the last version of the product? This is making some noise lately! Have you heard anything on the future of IDS? Is it going to be any more development of IDS down the road. Please advise!
jp
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list

j***@chubb.com

2013-01-29 15:49:24 UTC

Permalink

Thanks!

jp

From: Spokey Wheeler Gmail <***@gmail.com>

To: ***@chubb.com

Cc: Jonathan Leffler <***@gmail.com>, Informix List - IIUG <informix-***@iiug.org>

Date: 01/29/2013 10:42 AM

Subject: Re: IBM Informix 11.7 life cycle....

Erm. I've already seen a presentation on features in 12.1.

So no, development of IDS has not stopped.

Post by j***@chubb.com
Hi Guys!
Will IDS 11.70 be the last version of the product? This is making some

noise lately! Have you heard anything on the future of IDS? Is it going to
be any more development of IDS down the road. Please advise!

Post by j***@chubb.com
jp
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list

Marco Greco

2013-01-29 15:59:20 UTC

Permalink

Post by j***@chubb.com
Hi Guys!
Will IDS 11.70 be the last version of the product? This is making some noise
lately! Have you heard anything on the future of IDS? Is it going to be any
more development of IDS down the road. Please advise!
jp
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list

As it happens, a webcast has been just announced that introduces the latest
(and greatest) informix version:

The New IBM Informix: It's Simply Powerful
Date: Tuesday, March 5, 2013
Time: 10:00 AM PST

Registration:
http://event.on24.com/r.htm?e=571631&s=1&k=6740A7076E0FE9C59EBFDC80C8487D34&partnerref=IBM01

The list of new features is simply too long to be listed here, so why don't
you attend?

--
Ciao,
Marco
______________________________________________________________________________
Marco Greco /UK /IBM Standard disclaimers apply!

Structured Query Scripting Language http://www.4glworks.com/sqsl.htm
4glworks http://www.4glworks.com
Informix on Linux http://www.4glworks.com/ifmxlinux.htm

Spokey Wheeler Gmail

2013-01-29 15:41:01 UTC

Permalink

Erm. I've already seen a presentation on features in 12.1.

So no, development of IDS has not stopped.

Art Kagel

2013-01-29 16:17:33 UTC

Permalink

Development of Informix continues. The next big release, in the spring, of
Informix v12.10 code name Centaurus, will be better than ever!

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.

Post by j***@chubb.com
Hi Guys!
Will IDS 11.70 be the last version of the product? This is making some
noise lately! Have you heard anything on the future of IDS? Is it going to
be any more development of IDS down the road. Please advise!
jp
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list

Art Kagel

2013-01-29 16:28:32 UTC

Permalink

Hey, here's the link that went out yesterday morning announcing the web
cast that will announce Informix v12 and its features officially on March 5:

http://www.linkedin.com/groupAnswers?viewQuestionAndAnswers=&discussionID=208830825&gid=1671197&trk=eml-anet_dig-b_nd-pst_ttle-cn&ut=2yHYdJ37yfKRA1

Want to know what's in there? Where the future is going? Follow this link
to the Linked-In announcement and follow the sign-up link to attend:

http://event.on24.com/r.htm?e=571631&s=1&k=6740A7076E0FE9C59EBFDC80C8487D34&partnerref=IBM02<http://www.linkedin.com/redirect?url=http%3A%2F%2Fevent%2Eon24%2Ecom%2Fr%2Ehtm%3Fe%3D571631%26s%3D1%26k%3D6740A7076E0FE9C59EBFDC80C8487D34%26partnerref%3DIBM02&urlhash=mTdH&_t=tracking_anet>

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.

Post by j***@chubb.com
Hi Guys!
Will IDS 11.70 be the last version of the product? This is making some
noise lately! Have you heard anything on the future of IDS? Is it going to
be any more development of IDS down the road. Please advise!
jp
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list

Fernando Nunes

2013-01-29 17:22:45 UTC

Permalink

Can you be more specific about where/by whom you have heard the mentioned
"noise"?
It could be interesting to understand from what planet that came from.
The EVP is well known, Jerry Keesee has posted an article on his blog
telling when e will release the next version, Fred Ho posted an article
detailing some new functions that were to appear on the next version, IBM
has been keeping a release cycle of a major version every two years, there
were sessions with NDA agreements for customers, IIUG mentioned that the
next version would be an hot topic for this year conference... So... Can
you help me understand?
Thanks and regards.

Post by j***@chubb.com
Hi Guys!
Will IDS 11.70 be the last version of the product? This is making some
noise lately! Have you heard anything on the future of IDS? Is it going to
be any more development of IDS down the road. Please advise!
jp
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list

--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...

j***@chubb.com

2013-01-29 17:40:55 UTC

Permalink

Ooops! I wish I could but I do not want to put some in the hot water. This
was so loud that some folks up here may have hit the panic button and you
know when that happens, first word that comes out of the talk is 'MIGRATING
OFF MIGRATING OFF ,MIGRATING OFF'

jp

From: Fernando Nunes <***@gmail.com>

To: ***@chubb.com

Cc: Jonathan Leffler <***@gmail.com>, informix-list-***@iiug.org, Informix List - IIUG
<informix-***@iiug.org>

Date: 01/29/2013 12:23 PM

Subject: Re: IBM Informix 11.7 life cycle....

Can you be more specific about where/by whom you have heard the mentioned
"noise"?
It could be interesting to understand from what planet that came from.
The EVP is well known, Jerry Keesee has posted an article on his blog
telling when e will release the next version, Fred Ho posted an article
detailing some new functions that were to appear on the next version, IBM
has been keeping a release cycle of a major version every two years, there
were sessions with NDA agreements for customers, IIUG mentioned that the
next version would be an hot topic for this year conference... So... Can
you help me understand?
Thanks and regards.

On Tue, Jan 29, 2013 at 3:28 PM, <***@chubb.com> wrote:
Hi Guys!

Will IDS 11.70 be the last version of the product? This is making some
noise lately! Have you heard anything on the future of IDS? Is it going
to be any more development of IDS down the road. Please advise!

jp

_______________________________________________
Informix-list mailing list
Informix-***@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list

--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...

Art Kagel

2013-01-29 18:09:24 UTC

Permalink

Was it someone at IBM? Can you at least tell us that?

When someone cries "wolf" and management begins to panic, remind management
that IBM's entire "Smarter Planet", "Smarter Cities", and "Smarter
Utilities" campaigns depend heavily on Informix's ability to process
timeseries data orders of magnitude faster than any other database on the
market, whether it's Oracle, MS SQL Server, IBM DB2, or even dedicated
timeseries engines! That capability especially keeps being enhanced and
improved from version to version, even through the so called "patch"
versions. IBM NEEDS Informix so it's not going away anytime in the
foreseeable future!

Remind them that the national 911 system and the telephone networks of most
major corporations and US Government offices, agencies, and
pseudo-government corporations are managed by Informix databases. That the
ten largest retail organizations in the country and the eight largest
supermarket chains in the world depend on Informix for POS, inventory, and
other systems. That fully a quarter of this nations' Universities and
Colleges depend on it for ERP and student enrollment and faculty
management. That all of the VISA transactions in the US are processed
through an Informix database server. Nope, Informix isn't going anywhere.

Remind them that in the eleven years that IBM has owned the Informix
product line they have made more enhancements and improvements to both the
performance and to the stability of the Dynamic Server product than
Informix Corporation did in the entire 9 years the company owned it since
its introduction in 1994.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.

Post by j***@chubb.com
Ooops! I wish I could but I do not want to put some in the hot water.
This was so loud that some folks up here may have hit the panic button and
you know when that happens, first word that comes out of the talk is
'MIGRATING OFF MIGRATING OFF ,MIGRATING OFF'
jp
[image: Inactive hide details for Fernando Nunes ---01/29/2013 12:23:25
PM---Can you be more specific about where/by whom you have hear]Fernando
Nunes ---01/29/2013 12:23:25 PM---Can you be more specific about where/by
whom you have heard the mentioned "noise"?
01/29/2013 12:23 PM
Re: IBM Informix 11.7 life cycle....
------------------------------
Can you be more specific about where/by whom you have heard the mentioned
"noise"?
It could be interesting to understand from what planet that came from.
The EVP is well known, Jerry Keesee has posted an article on his blog
telling when e will release the next version, Fred Ho posted an article
detailing some new functions that were to appear on the next version, IBM
has been keeping a release cycle of a major version every two years, there
were sessions with NDA agreements for customers, IIUG mentioned that the
next version would be an hot topic for this year conference... So... Can
you help me understand?
Thanks and regards.
Hi Guys!
Will IDS 11.70 be the last version of the product? This is making some
noise lately! Have you heard anything on the future of IDS? Is it going to
be any more development of IDS down the road. Please advise!
jp
_______________________________________________
Informix-list mailing list*
**http://www.iiug.org/mailman/listinfo/informix-list*<http://www.iiug.org/mailman/listinfo/informix-list>
--
Fernando Nunes
Portugal
*
**http://informix-technology.blogspot.com*<http://informix-technology.blogspot.com/>
My email works... but I don't check it frequently...
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list

Fernando Nunes

2013-01-29 19:02:15 UTC

Permalink

Well... If you can't tell us that's ok...
However, if your company decides to migrate from whatever, based on obvious
FUD, false rumours that contradict what is well known on the market (just
note how many answers you had immediately from non IBMers), than I'd be
very worry about the company ability to make sensible business decisions....
And in that case you know what should happen: GET ANOTHER JOB.... GET
ANOTHER JOB...
Regards.

Post by j***@chubb.com
Ooops! I wish I could but I do not want to put some in the hot water. This
was so loud that some folks up here may have hit the panic button and you
know when that happens, first word that comes out of the talk is 'MIGRATING
OFF MIGRATING OFF ,MIGRATING OFF'
jp
[image: Inactive hide details for Fernando Nunes ---01/29/2013 12:23:25
PM---Can you be more specific about where/by whom you have hear]Fernando
Nunes ---01/29/2013 12:23:25 PM---Can you be more specific about where/by
whom you have heard the mentioned "noise"?
01/29/2013 12:23 PM
Re: IBM Informix 11.7 life cycle....
------------------------------
Can you be more specific about where/by whom you have heard the mentioned
"noise"?
It could be interesting to understand from what planet that came from.
The EVP is well known, Jerry Keesee has posted an article on his blog
telling when e will release the next version, Fred Ho posted an article
detailing some new functions that were to appear on the next version, IBM
has been keeping a release cycle of a major version every two years, there
were sessions with NDA agreements for customers, IIUG mentioned that the
next version would be an hot topic for this year conference... So... Can
you help me understand?
Thanks and regards.
Hi Guys!
Will IDS 11.70 be the last version of the product? This is making some
noise lately! Have you heard anything on the future of IDS? Is it going to
be any more development of IDS down the road. Please advise!
jp
_______________________________________________
Informix-list mailing list*
**http://www.iiug.org/mailman/listinfo/informix-list*<http://www.iiug.org/mailman/listinfo/informix-list>
--
Fernando Nunes
Portugal
*
**http://informix-technology.blogspot.com*<http://informix-technology.blogspot.com/>
My email works... but I don't check it frequently...

--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...

j***@chubb.com

2013-01-29 19:09:01 UTC

Permalink

Quiet guys!

It came from someone at IBM last year.....one folk there said that to our
architecture department but the talks of migrating were just renewed again
with the new year. I just wanted to confirm.

Thanks Again!

jp

From: Art Kagel <***@gmail.com>

To: ***@chubb.com

Cc: Informix List - IIUG <informix-***@iiug.org>

Date: 01/29/2013 01:10 PM

Subject: Re: IBM Informix 11.7 life cycle....

Was it someone at IBM? Can you at least tell us that?

When someone cries "wolf" and management begins to panic, remind management
that IBM's entire "Smarter Planet", "Smarter Cities", and "Smarter
Utilities" campaigns depend heavily on Informix's ability to process
timeseries data orders of magnitude faster than any other database on the
market, whether it's Oracle, MS SQL Server, IBM DB2, or even dedicated
timeseries engines! That capability especially keeps being enhanced and
improved from version to version, even through the so called "patch"
versions. IBM NEEDS Informix so it's not going away anytime in the
foreseeable future!

Remind them that the national 911 system and the telephone networks of most
major corporations and US Government offices, agencies, and
pseudo-government corporations are managed by Informix databases. That the
ten largest retail organizations in the country and the eight largest
supermarket chains in the world depend on Informix for POS, inventory, and
other systems. That fully a quarter of this nations' Universities and
Colleges depend on it for ERP and student enrollment and faculty
management. That all of the VISA transactions in the US are processed
through an Informix database server. Nope, Informix isn't going anywhere.

Remind them that in the eleven years that IBM has owned the Informix
product line they have made more enhancements and improvements to both the
performance and to the stability of the Dynamic Server product than
Informix Corporation did in the entire 9 years the company owned it since
its introduction in 1994.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.

On Tue, Jan 29, 2013 at 12:40 PM, <***@chubb.com> wrote:
Ooops! I wish I could but I do not want to put some in the hot water.
This was so loud that some folks up here may have hit the panic button
and you know when that happens, first word that comes out of the talk is
'MIGRATING OFF MIGRATING OFF ,MIGRATING OFF'

jp

Inactive hide details for Fernando Nunes ---01/29/2013 12:23:25 PM---Can
you be more specific about where/by whom you have hearFernando Nunes
---01/29/2013 12:23:25 PM---Can you be more specific about where/by whom
you have heard the mentioned "noise"?

From: Fernando Nunes <***@gmail.com>

To: ***@chubb.com

Cc: Jonathan Leffler <***@gmail.com>,
informix-list-***@iiug.org, Informix List - IIUG <
informix-***@iiug.org>

Date: 01/29/2013 12:23 PM

Subject: Re: IBM Informix 11.7 life cycle....

Can you be more specific about where/by whom you have heard the mentioned
"noise"?
It could be interesting to understand from what planet that came from.
The EVP is well known, Jerry Keesee has posted an article on his blog
telling when e will release the next version, Fred Ho posted an article
detailing some new functions that were to appear on the next version, IBM
has been keeping a release cycle of a major version every two years,
there were sessions with NDA agreements for customers, IIUG mentioned
that the next version would be an hot topic for this year conference...
So... Can you help me understand?
Thanks and regards.

On Tue, Jan 29, 2013 at 3:28 PM, <***@chubb.com> wrote:
Hi Guys!

Will IDS 11.70 be the last version of the product? This is making
some noise lately! Have you heard anything on the future of IDS? Is
it going to be any more development of IDS down the road. Please
advise!

jp

_______________________________________________
Informix-list mailing list
Informix-***@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list

--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...

_______________________________________________
Informix-list mailing list
Informix-***@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list

Art Kagel

2013-01-29 19:16:53 UTC

Permalink

FUD from within IBM. Don't we have enough trouble without that!?!?!?

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.

Post by j***@chubb.com
Quiet guys!
It came from someone at IBM last year.....one folk there said that to our
architecture department but the talks of migrating were just renewed again
with the new year. I just wanted to confirm.
Thanks Again!
jp
[image: Inactive hide details for Art Kagel ---01/29/2013 01:10:01
PM---Was it someone at IBM? Can you at least tell us that? When som]Art
Kagel ---01/29/2013 01:10:01 PM---Was it someone at IBM? Can you at least
tell us that? When someone cries "wolf" and management begi
01/29/2013 01:10 PM
Re: IBM Informix 11.7 life cycle....
------------------------------
Was it someone at IBM? Can you at least tell us that?
When someone cries "wolf" and management begins to panic, remind
management that IBM's entire "Smarter Planet", "Smarter Cities", and
"Smarter Utilities" campaigns depend heavily on Informix's ability to
process timeseries data orders of magnitude faster than any other database
on the market, whether it's Oracle, MS SQL Server, IBM DB2, or even
dedicated timeseries engines! That capability especially keeps being
enhanced and improved from version to version, even through the so called
"patch" versions. IBM NEEDS Informix so it's not going away anytime in the
foreseeable future!
Remind them that the national 911 system and the telephone networks of
most major corporations and US Government offices, agencies, and
pseudo-government corporations are managed by Informix databases. That the
ten largest retail organizations in the country and the eight largest
supermarket chains in the world depend on Informix for POS, inventory, and
other systems. That fully a quarter of this nations' Universities and
Colleges depend on it for ERP and student enrollment and faculty
management. That all of the VISA transactions in the US are processed
through an Informix database server. Nope, Informix isn't going anywhere.
Remind them that in the eleven years that IBM has owned the Informix
product line they have made more enhancements and improvements to both the
performance and to the stability of the Dynamic Server product than
Informix Corporation did in the entire 9 years the company owned it since
its introduction in 1994.
Art
Art S. Kagel
Advanced DataTools (*www.advancedatatools.com*<http://www.advancedatatools.com/>
)
Blog: *http://informix-myview.blogspot.com/*<http://informix-myview.blogspot.com/>
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
Ooops! I wish I could but I do not want to put some in the hot water.
This was so loud that some folks up here may have hit the panic button and
you know when that happens, first word that comes out of the talk is
'MIGRATING OFF MIGRATING OFF ,MIGRATING OFF'
jp
[image: Inactive hide details for Fernando Nunes ---01/29/2013
12:23:25 PM---Can you be more specific about where/by whom you have hear]Fernando
Nunes ---01/29/2013 12:23:25 PM---Can you be more specific about where/by
whom you have heard the mentioned "noise"?
To:*
01/29/2013 12:23 PM
Re: IBM Informix 11.7 life cycle....
------------------------------
Can you be more specific about where/by whom you have heard the
mentioned "noise"?
It could be interesting to understand from what planet that came from.
The EVP is well known, Jerry Keesee has posted an article on his blog
telling when e will release the next version, Fred Ho posted an article
detailing some new functions that were to appear on the next version, IBM
has been keeping a release cycle of a major version every two years, there
were sessions with NDA agreements for customers, IIUG mentioned that the
next version would be an hot topic for this year conference... So... Can
you help me understand?
Thanks and regards.
Hi Guys!
Will IDS 11.70 be the last version of the product? This is
making some noise lately! Have you heard anything on the future of IDS? Is
it going to be any more development of IDS down the road. Please advise!
jp
_______________________________________________
Informix-list mailing list*
**http://www.iiug.org/mailman/listinfo/informix-list*<http://www.iiug.org/mailman/listinfo/informix-list>
--
Fernando Nunes
Portugal*
**http://informix-technology.blogspot.com*<http://informix-technology.blogspot.com/>
My email works... but I don't check it frequently...
_______________________________________________
Informix-list mailing list*
**http://www.iiug.org/mailman/listinfo/informix-list*<http://www.iiug.org/mailman/listinfo/informix-list>

Fernando Nunes

2013-01-29 22:58:51 UTC

Permalink

A name...?

--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...

Jerry Keesee

2013-01-30 22:30:49 UTC

Permalink

Hi,

Informix is alive and well. We just finished a year where we adding over
100 new business partners spanning many different industries. We also
continued to make significant enhancements to our In Memory Columnar
Warehouse Accelerator (IWA) which adding a number of new customers over
the course of 2012. We started an EVP for our next major release last
summer and just announced plans for a Web Cast to discuss our next
release.

You can get more information on the Web Cast here

I would be happy to meet and discuss in more detail if you would like.

Regards,
Jerry

Jerry Keesee
World Wide Director, Informix Software
IBM Data Management
Tel:(913)599-8713
Cell:(913)710-7472

From: ***@chubb.com
To: Jonathan Leffler <***@gmail.com>
Cc: informix-list-***@iiug.org, Informix List - IIUG
<informix-***@iiug.org>
Date: 01/29/2013 09:48 AM
Subject: IBM Informix 11.7 life cycle....
Sent by: informix-list-***@iiug.org

Hi Guys!

Will IDS 11.70 be the last version of the product? This is making some
noise lately! Have you heard anything on the future of IDS? Is it going to
be any more development of IDS down the road. Please advise!

jp_______________________________________________
Informix-list mailing list
Informix-***@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list