select ltrim(rtrim(A.prodname)) prodname, A.gradename,
B.Z0010, B.Z0320, B.Z0460, B.Z0570, B.Z0590 from
lgtc_gradeinfo_t A,
( select gradename, Z0010, Z0320, Z0460, Z0570, Z0590 from (
select gradename,
sum(double(case physicode when '0010' then stdvalue
else null end)) "Z0010",
sum(double(case physicode when '0320' then stdvalue
when '0321' then stdvalue
when '0340' then stdvalue
when '0342' then stdvalue
when '0350' then stdvalue
when '1530' then stdvalue
when '1550' then stdvalue
else null end)) "Z0320",
sum(double(case physicode when '0460' then stdvalue
when '0471' then stdvalue
when '0480' then stdvalue
when '0481' then stdvalue
when '0490' then stdvalue
when '1560' then stdvalue
when '1570' then stdvalue
else null end)) "Z0460",
sum(double(case physicode when '0570' then stdvalue
when '0571' then stdvalue
when '0572' then stdvalue
when '0580' then stdvalue
when '0581' then stdvalue
when '0582' then stdvalue
when '4030' then stdvalue
else null end)) "Z0570",
sum(double(case physicode when '0590' then stdvalue
when '0600' then stdvalue
when '0610' then stdvalue
when '0611' then stdvalue
when '0612' then stdvalue
when '0613' then stdvalue
when '0620' then stdvalue
else null end)) "Z0590" from ( select gradename,
ltrim(rtrim(physicode)) physicode, ltrim(rtrim(stdvalue)) stdvalue
from lgtc_gradeprop_t where ltrim(rtrim(physicode)) in ( '0010',
'0320', '0321', '0340', '0342', '0350', '1530', '1550',
'0460', '0471', '0480', '0481', '0490', '1560', '1570',
'0570', '0571', '0572', '0580', '0581', '0582', '4030',
'0590', '0600', '0610', '0611', '0612', '0613', '0620'
)
and ltrim(rtrim(stdvalue)) not in ('-', ' ') and
substr(ltrim(rtrim(stdvalue)), 1, 1) not in ('<', '>')
group by gradename, physicode, stdvalue ) aa
group by gradename ) bb where Z0010 between 1200 and 1500 ) B
where A.gradename = B.gradename order by A.prodname,
A.gradename
[IBM][CLI Driver][DB2/NT] SQL0443N "SYSFUN.DOUBLE" 루틴(특정 이름
"SQL001108194511352")이 진단 텍스트 "SYSFUN:11"와(과) 함께 오류
SQLSTATE를 리턴했습니다. SQLSTATE=38552
[IBM][CLI Driver][DB2/NT] SQL0501N FETCH 또는 CLOSE문에서 지정된
커서가 열려 있지 않습니다. SQLSTATE=24501
0 rows selected because of ERROR.
무슨에러인지는 찾아봐서 아는데 해결책을 모르겠더군요... 답변좀
부탁드립니다
|