안녕하세요
제가 SQL문을 이렇게 작성을 하였습니다.
select TRANSLAGE(CHAR(T1.Stl_Len), '', '0')
from prod.gda1110t t1, prod.gda1100t t2
where t1.sang_jisi_ymd = hex(current date)
and t1.saupjang_gbn = 'I'
and t2.sang_jisi_fmt_gbn in ('D', 'E')
and t2.car_no <> ' '
and t1.sang_jisi_ymd = t2.sang_jisi_ymd
and t1.saupjang_gbn = t2.saupjang_gbn
and t1.sang_jisi_seq = t2.sang_jisi_seq
and t1.sang_jisi_sub_seq = t1.sang_jisi_sub_seq
실행을 하니 [DB2] SQL0104N An unexpected token "TRANSLAGE" was found following "". Expected tokens may include: "AVG, SUBSTR, MAX, HEX, FLOAT, DATE, YEAR, ETC.". SQLSTATE=42601 이런 오류 메시지가 나오는데 이유를 못 찾겠어요..
도와주세요 ^^ |