Problem with Informix 7.3
Posted in 1998
Hi there,
We are facing a problem with the following query. We've developed it using
Informix On-line workgroup Server 7.2 on Windows NT and it's running fine.
Also it is running fine on Informix On-line Dynamic server on Sco unix.
But When we tried to port it on to the production environment, with
Informix dynamic server 7.3 on SCO Unix, it is coming out with the
following error.
"the column expression must be in the group by list"
Any help is greatly appreciated.
Deepak
------
select code, sp_test(sum(value)) from sample group by code ;The query calls stored procedure sp_test.
procedure sp_test :
create procedure sp_test(ai_value int) returning int ;begin
retun ai_value ;
end
end procedure
the structure of the table sample is
sample
(
code char(1),
value int
)
____________________________________________________________________
Get free e-mail and a permanent address at http://www.netaddress.com/?N=1