안녕하세요

제가 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 이런 에러 메시지가 나오는데 이유를 못 찾겠습니다.

아시는 분 좀 부탁드릴께요