SELECT PYBCK_DT
   , ACCT_MGT_NO
   , SUM_GRNT_AMT
   , OVER_SUM_GRNT_AMT
   , 30000000 - OVER_SUM_GRNT_AMT
FROM (    
SELECT  A.PYBCK_DT
        , A.ACCT_MGT_NO
        , SUM(GRNT_AMT) AS SUM_GRNT_AMT
        , (SELECT SUM(GRNT_AMT) FROM party.BSCR_GRNT_DOC_SBRATE_DTL WHERE ACCT_MGT_NO = '22073035459' AND PYBCK_DT <= A.PYBCK_DT ) AS OVER_SUM_GRNT_AMT
  FROM  party.BSCR_GRNT_DOC_SBRATE_DTL A 
 WHERE  A.ACCT_MGT_NO = '22073035459' 
 GROUP  BY PYBCK_DT, ACCT_MGT_NO
 ) s

구현을 해봤는데 db2에서는 스칼라 쿼리가 먹히질 않습니다.

(SELECT SUM(GRNT_AMT) FROM party.BSCR_GRNT_DOC_SBRATE_DTL WHERE ACCT_MGT_NO = '22073035459' AND PYBCK_DT <= A.PYBCK_DT ) AS OVER_SUM_GRNT_AMT
 

이부분을 db2로 구현하고자 할때 어떻게 해야하는지 도움주세요...

with TA (C1,C2,C3) AS
(VALUES
  ('55784006501', '2001-10-02', 10000)
 ,('55784006501', '2001-10-03', 20000)
 ,('55784006501', '2001-11-05', 10000)
 ,('55784006501', '2001-12-04', 30000) )

,TB(Ca) AS (VALUES 3000000)

select *
from (
select c1 계좌번호 ,max(c2) over(partition by t2.RN) 거래년월일
       ,case when t1.rn = t2.rn then c3 end 거래금액
       ,sum(c3) over(PARTITION by t2.rn) 누계금액,  ca - sum(c3) over(PARTITION by t2.rn) 차감누계값
from ( select c1,c2,c3, row_number() over(PARTITION by c1 order by c2 desc) rn, ca from ta, tb ) t1, (select rownum rn from syscat.tables where rownum<20) t2
where t2.rn <= t1.rn
order by 2
) where 거래금액 is not null