Request for Function in New Informix Version
Posted in 2005
Topics: General Discussion
tomcaml@yahoo.com — — source: Usenet: comp.databases.informix
This would be great to see in Informix: Row Aggregates and the Compute Clause The SQL Server COMPUTE clause is used to generate row aggregate functions (SUM, AVG, MIN, MAX, and COUNT), which appear as additional rows in the query results. It allows you to see detail and summary rows in one set of results. You can calculate summary values for subgroups, and you can calculate more than one aggregate function for the same group. The Informix SELECT command syntax does not support the COMPUTE clause. Tom
↪ replying to tomcaml@yahoo.com
scottishpoet — — source: Usenet: comp.databases.informix
How about using DB2/Informix Office connect, select the normal values into an excel spreadsheet and use excels functions?