*오류메세지

------------------------------------------------------------------------------------

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는 이번에 처음 경험하는지라..................................