[IBM][Client Access Express ODBC 드라이버 (32 비트)][DB2/400 SQL]SQL0666 - Estimated query processing time 31 exceeds limit 30.
vb와 as400(db2)를 ADO롤 연결해서 쓰고있는데 이런 에러가 나는군요
DB2는 첨이라 도통 모르겠네요
<궤리>
SELECT AJUNGU ,ACDGU , SUM(AGUM) FROM GQC0010 WHERE CASE AFACD1 WHEN '11102' THEN ABCODE WHEN '11103' THEN ABCODE ELSE ACSTCD END = 'HS001' AND ADATE BETWEEN '20030101' AND '20031031' AND ((AJUNGU = 'R' AND ACDGU = 'D') OR (AJUNGU NOT IN ('S','R') AND AFACD1 IN ('11105' ,'21106'))) AND ASAJAN = 'HD01' GROUP BY AJUNGU ,ACDGU |