List,
Using SAPDB 7.5.00.16 and received the following error but can find no
reference to this error number or cause. Your assistance is greatly
appreciated.
Keith Arnold
---- Error -------------------------------
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
General error;-9206 POS(1) System error: AK Duplicate catalog
information:FF0000210000030100B100.
SELECT Productname as "Product",
TN as "Test",
Description as "Test Description",
fixed(AVG(TCP),20,2) as "Avg Cp",
fixed(AVG(TCPK),20,2) as "Avg Cpk",
SUM(outliers) as "Outlier Count",
total "Device Count"
FROM v_lotinfo l, teststats t, (select sum(devicecount) as total
from lotinfo
where ProductID IN ('38')
AND TesterNodeName IN
('BENVENUE','CX02','CX05','P4FSN002','P4FSN003')
AND date(LotStartTime) BETWEEN
date('2005-07-15') AND
date('2005-07-22')
AND duplicate = 0 )
WHERE l.report_id = t.report_id (+)
AND ProductID IN ('38')
AND TesterNodeName IN
('BENVENUE','CX02','CX05','P4FSN002','P4FSN003')
AND date(LotStartTime) BETWEEN date('2005-07-15') AND
date('2005-07-22')
AND duplicate = 0
GROUP BY Productname, TN, Description, total
ORDER BY 1, 2
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
