마농님이 하신거 db2에 맞게 바꿨어요

with SALETRS(DATE,NO,SUBNO,CHAMT,JOBAMT,CTCODE,VDCODE) as (values
('20051101','2031','0',1000 ,'0','a','12665'),
('20051101','2031','1',4000 ,'0','a','12665'),
('20051101','2032','0',2000 ,'0','a','12665'),
('20051101','2032','1',3000 ,'0','a','12665'),
('20051101','2034','0',10000,'0','b','12602'),
('20051101','2035','0',20000,'0','b','12602'),
('20051101','2036','0',4000 ,'0','b','12602'),
('20051101','2050','0',6000 ,'0','b','12503'),
('20051101','2014','0',4000 ,'0','c','12229'),
('20051101','2016','0',6000 ,'0','c','12229'),
('20051101','2017','0',15000,'0','c','12123'),
('20051101','2020','0',25000,'0','c','13113'),
('20051101','2021','0',4000 ,'0','c','12999'),
('20051101','2022','0',16000,'0','c','12999'))

SELECT CASE no WHEN 1 THEN DENSE_RANK() OVER(ORDER BY ctcode) END no,
       CASE no WHEN 1 THEN ctcode END  ctcode,
       CASE no WHEN 1 THEN '기간' ELSE '일반' END gubun,
       CASE no WHEN 1 THEN num1 WHEN 2 THEN num2 END num,
       CASE no WHEN 1 THEN sa_chamt1 WHEN 2 THEN sa_chamt2 END sa_chamt,
       CASE no WHEN 1 THEN sa_chamt1 WHEN 2 THEN sa_chamt2 END * 100 /
       SUM(CASE no WHEN 1 THEN sa_chamt1 WHEN 2 THEN sa_chamt2 END) OVER(PARTITION BY no) percent
FROM
(
SELECT ctcode,
       COUNT(DISTINCT CASE SUBSTR(vdcode,3,3) WHEN '999' THEN NULL ELSE no END) num1,
       VALUE(SUM(CASE SUBSTR(vdcode,3,3) WHEN '999' THEN 0 ELSE chamt END),0) sa_chamt1,
       COUNT(DISTINCT CASE SUBSTR(vdcode,3,3) WHEN '999' THEN no ELSE NULL END) num2,
       VALUE(SUM(CASE SUBSTR(vdcode,3,3) WHEN '999' THEN chamt ELSE 0 END),0) sa_chamt2
  FROM SALETRS
 WHERE date = '20051101'
GROUP BY ctcode ) A, (VALUES(1),(2)) as B(NO);

바꾸기님 정말 감사합니다.

근데 해보니깐

Error: SQL0104 - Token OVER was not valid. Valid tokens: END. (State:37000, Native Code: FFFFFF98)
에러가 나는데요.

혹시 db2 버전이 4.4버전이라서 OVER함수가 없어서 나는 거 아닌가 싶네요...

맞나요?