Beefman asked
>
> I am trying to show our management the benefits of upgrading our
> informix versions and would like to know the benfits of the following
> upgrade.
>
> We currently are useing IDS 7.31.UD4 on AIX 4.3 as well as I-4GL
> 7.20.UE2 on the same platform.
>
> I would like to upgrade to IDS 9.4 on AIX 5.2 as well as I-4GL 7.31.
>
> I need to know all of the benefits of this upgrade, could anyone here
> please help.
>
It will be supported for longer than 7.3, so you have more time before
you are forced to DB2 or O. :-(

The rest are not so important and some might not seem to be improvements !!

1 *Collection Derived Tables
2. *Datablades
3. *Temporary Smart Large Objects
4. *J/Foundation Support for JDK 1.3 including Hotspot JVM
5. *UDRs in Java
6. *Improvements to Enterprise Replication
7. *Functional Indexes
8. *Query plan without execute
9. *Iterator function
10. *Order by column not in select list
11. *varchar up to 32k chars
12. *Embedded NL in char fields
13. *Enterprise Gateway Manager
15. *User defined aggregates
16. *SQL statement cache
17. *Cross join / right outer join
18. *128-character identifiers
19. *Data type casting
20. *HDR and ER on samesystem
21. *Non logging raw tables
22. *Password encryption using CSS/CSM
23. *Chunks greater than 2 GB
24. *New alarm program

Sorry about the missing no 14

Colin Bull

sending to informix-list