안녕하세요
제가 SQL문을 이렇게 작성했습니다.
SELECT T1.Order_No,T1.Pummok_Cd, T1.Stl_Gangj_Cd, T1.Jepum_Size_Cd,
CASE WHEN T1.Bd_Cnt IS NULL THEN 0 ELSE T1.Bd_Cnt END ||
SUM(CASE WHEN T2.Bind_Cnt IS NULL THEN 0 ELSE T2.Bind_Cnt END) Bind_Cnt,
CHAR(T1.Stl_Len) Stl_Len, T1.Car_No, T1.Size_Id, T1.Stl_Gangj_Id
FROM (
SELECT A.Order_No, A.Pummok_Cd, A.Stl_Gangj_Cd, A.Jepum_Size_Cd, A.Bd_Cnt, A.Stl_Len, B.Car_No, C.Size_Id, D.Stl_Gangj_Id
FROM TEST.GDA1110T A, TEST.GDA1100T B, TEST.GSZ1060T C, TEST.GQB1010T D
WHERE A.Sang_Jisi_Ymd = B.Sang_Jisi_Ymd AND A.Saupjang_Gbn = B.SaupJang_Gbn
AND A.Sang_Jisi_Seq = B.Sang_Jisi_Seq AND A.Sang_Jisi_Sub_Seq = B.Sang_Jisi_Sub_Seq
AND A.Pummok_Cd = C.Pummok_Cd AND A.Jepum_Size_Cd = C.Prod_Cd
AND A.Stl_Gangj_Cd = D.Stl_Gangj_Cd AND A.Sang_Jisi_Ymd >= '20050228'
AND A.Sang_Jisi_Ymd <= '20050501' AND A.Order_No = '422005040376'
AND B.Car_No = '경북99아8171' AND B.Sang_Jisi_Fmt_Gbn IN ('D', 'E')
AND A.Jepum_Yd_Cd = 'H1' AND A.Saupjang_Gbn = 'I' ) T1 LEFT OUTER JOIN TEST.GDC1250T T2
ON T1.Order_No = T2.Job_Jisi_No AND T1.Pummok_Cd = T2.Pummok_Cd
AND T1.Stl_Gangj_Cd = T2.Stl_Gangj_Cd AND T1.Jepum_Size_Cd = T2.Jepum_Size_Cd
AND T1.Stl_Len = T2.Stl_Len
GROUP BY T1.Order_No, T1.Pummok_Cd, T1.Stl_Gangj_Cd, T1.Jepum_Size_Cd, T1.Bd_Cnt, T1.Stl_Len, T1.Car_No, T1.Size_Id, T1.Stl_Gangj_Id
헌데 [DB2] SQL0171N The data type, length or value of argument "00000001" of routine "||" is incorrect. SQLSTATE=42815 이런 에러 메시지가 나오는데 이유를 못 찾겠습니다.
아시는 분 좀 부탁드릴께요
|