aparnaramsharma
Technical User
Hi all,
I am using DB2 7.1.1 on OS/390.
When I issue the following query:
select emplid, p1_alot_hours*5, sum(p1_alot_hours)
from
ps_p1_abs_accrual
where emplid = '100334'
group by emplid, p1_alot_hours*5
------------------------------------------------------------
I get the following error:
SQL0104N An unexpected token "*" was found following "". Expected tokens may
include: "FOR WITH FETCH ORDER UNION EXCEPT QUERYNO OPTIMIZE ".
SQLSTATE=42601
What could be the reason for the error? Does not DB2 on Mainframes support calculations in the group by clause. Is there any setup for enabling this feature.
Thanks in advance for the responses.
Aparna
I am using DB2 7.1.1 on OS/390.
When I issue the following query:
select emplid, p1_alot_hours*5, sum(p1_alot_hours)
from
ps_p1_abs_accrual
where emplid = '100334'
group by emplid, p1_alot_hours*5
------------------------------------------------------------
I get the following error:
SQL0104N An unexpected token "*" was found following "". Expected tokens may
include: "FOR WITH FETCH ORDER UNION EXCEPT QUERYNO OPTIMIZE ".
SQLSTATE=42601
What could be the reason for the error? Does not DB2 on Mainframes support calculations in the group by clause. Is there any setup for enabling this feature.
Thanks in advance for the responses.
Aparna