sqlcode나  sqlstate가 무엇인지 알수있나요?

Error: SQL0199 - Keyword UNION not expected. Valid tokens: ). (State:37000, Native Code: FFFFFF39)
입니다.

안에 서브쿼리는 잘 실행되는데... 밖에 group by 한게 에러나는데요

db2에서는 union 과 서브쿼리시 상위select에서 group by 를 사용할수 없습니다.

아래처럼 사용하시면 될껍니다

=====================================================

select a.sa_ctcode, a.ct_ltd,
       sum(a.sa_2003), sum(a.sa_2004), sum(a.sa_2005)
from
(
select sa_ctcode, ct_ltd, sa_date
  case
  when substr(sa_date,1,4)  = '2003'
  then sum(sa_chamt)
  else 0
  end as sa_2003,
  case
  when substr(sa_date,1,4)  = '2004'
  then sum(sa_chamt)
  else 0
  end as sa_2004,
  case
  when substr(sa_date,1,4)  = '2005'
  then sum(sa_chamt)
  else 0
  end as sa_2005
from salelib.saletrs
where sa_hisa = '11'
and substr(sa_date,1,6) in ('200301','200401','200501')
group by sa_ctcode, ct_ltd, sa_date
)a
group by a.sa_ctcode, a.ct_ltd
====================================================

outer조인은 추가로 넣어주시면 될껍니다

V7,V8에서 테스트했습니다.

select c1,count(*)
from (
select 1 c1,count(*) from org
group by DEPTNUMB
union all
select 2 c1,count(*) from org
group by DEPTNUMB
) a
group by c1;

C1          2         
----------- -----------
          1           8
          2           8

  2 record(s) selected.

 그럼 위의 구문이 이상없다는건가요? 도님...?

db2 version이 어떻게 되나요?

에러 코드에 대해 이런게 있네요

Beginning with R520, a FULLSELECT on derived tables can now be done. In previous releases, trying this may have resulted in the following message: SQL0199 - Keyword UNION not expected. Valid tokens: ).

The FULLSELECT is a component of the select-statement and the CREATE VIEW statement. A FULLSELECT enclosed in parenthesis is called a subquery . A FULLSELECT specifies a result table. If UNION is not used, the result of the FULLSELECT is the result of the specified subselect. UNION derives a result table by combining two other result tables. The following is a simple example of how support for FULLSELECT of a derived table can work at R520:

select sum(derived.fld1) from (select fld1 from filea UNION select fld1 from fileb) as Derived                                                          
This is documented in the SQL Reference manual, in the chapter called Queries , found in the iSeries Information Center at the following Web site:

http://publib.boulder.ibm.com/html/as400/infocenter.html .