Problem with insert-Statement
Hi,
I've a problem with an insert-Statement.
I want to do something like this:
[...]
insert into temp_table
(var_a, var_b, var_c)
select var_a, round(var_b/10,2), var_c
from table
group by var_a, var_b
having mod(var_b,2)=0;
[...]
The types of var_a, var_b and var_c are smallint.
When I compile it under Informix 4.17.UC1 I've got no problems. But when
I compile it under Informix 4.10.UD2 I got this error message:
|___________________^
|
| A grammatical error has been found on line 109, character
21.
| The construct is not understandable in its context.
| See error number -4373.
|_______________________^
|
| A grammatical error has been found on line 109, character
26.
| The construct is not understandable in its context.
| See error number -4373.
|________________________^
|
| A grammatical error has been found on line 109, character
27.
| The construct is not understandable in its context.
| See error number -4373.
I've no idea to solve this problem.
Ciao
Christoph