SELECT
VHLDDT AS STTT ,
( SELECT CASE WHEN C.RATGBN ='YEN' THEN C.RATRAT/100 ELSE C.RATRAT END
FROM COMLIB.RATEF AS C
WHERE C.RATSAL ='M'
AND C.RATGBN = A.VHCURR
AND C.RATYYY = SUBSTR(A.VHLDDT,1,4)
AND C.RATMMM = SUBSTR(A.VHLDDT, 5,2)
AND C.RATDAY = SUBSTR(A.VHLDDT, 7,2)
) AS RATRAT
FROM PURDLIB.PVH AS A
WHERE A.VHLDDT BETWEEN '20081101' AND '20081131'
위와 같은 쿼리를 날리면 잘 실행이 됩니다.
그런데 위의 쿼리를 밖으로 한번 더 묶으면..
-->>
SELECT AA.STTT , AA.RATRAT
FROM
(
SELECT
VHLDDT AS STTT ,
( SELECT CASE WHEN C.RATGBN ='YEN' THEN C.RATRAT/100 ELSE C.RATRAT END
FROM COMLIB.RATEF AS C
WHERE C.RATSAL ='M'
AND C.RATGBN = A.VHCURR
AND C.RATYYY = SUBSTR(A.VHLDDT,1,4)
AND C.RATMMM = SUBSTR(A.VHLDDT, 5,2)
AND C.RATDAY = SUBSTR(A.VHLDDT, 7,2)
) AS RATRAT
FROM PURDLIB.PVH AS A
WHERE A.VHLDDT BETWEEN '20081101' AND '20081131'
) AS AA
이런식으로 한번더 묶어서 돌리면 에러가 납니다.
Error: SQL0901 - SQL system error. (State:S1000, Native Code: FFFFFC7B)
문제가 무엇인지..버전문제인지..고수님들의 도움을..
|