기존에 잘 사용하던 쿼리문이 각 테이블의 데이터타입 변경후부터 오류가 납니다.
*오류메세지
------------------------------------------------------------------------------------
ERROR [42825] [IBM][DB2/HPUX-IA64] SQL0415N
The data types of corresponding columns are not compatible in a fullselect that includes a set operator or in the multiple rows of a VALUES clause of an INSERT or fullselect. SQLSTATE=42825
------------------------------------------------------------------------------------
* 데이터 타입이 변경된 필드
------------------------------------------------------------------------------------
aaa 테이블의 dtmnlrgcd 필드를 char() --> int
aab 테이블의 dtmnmdlcd, dtmnsmlcd 이 세개의 필드를 char() --> int
aac 테이블의 dtmnlrgcd, dtmnmdlcd, dtmnsmlcd 이 세개의 필드를 char() --> int
------------------------------------------------------------------------------------
SELECT dtmnlrgcd, dtmnmdlcd, dtmnsmlcd, dtmntitl, depth
FROM(
SELECT 1 AS depth, dtmnlrgcd AS dtmncd, dtmnlrgcd AS dtmnlrgcd, ' ' AS dtmnmdlcd, ' ' AS dtmnsmlcd, dtmnlrgtitl AS dtmntitl
FROM aaa
UNION ALL
SELECT 2 AS depth, dtmnmdlcd AS dtmncd, dtmnlrgcd AS dtmnlrgcd, dtmnmdlcd, ' ' AS dtmnsmlcd, dtmnmdltitl AS dtmntitl
FROM aab
UNION ALL
SELECT 3 AS depth, dtmnsmlcd AS dtmncd, dtmnlrgcd AS dtmnlrgcd, dtmnmdlcd, dtmnsmlcd, dtmnsmltitl AS dtmntitl
FROM aac
)
as dtmntree
ORDER BY dtmnlrgcd, dtmnmdlcd, dtmnsmlcd, depth desc
혹시나 하는 마음에 MS-SQL에 똑같이 테이블 만들어서 돌리면 잘 돌아갑니다... -.-
DB2는 이번에 처음 경험하는지라..................................
답변부탁드립니다...
|