Invalid SQL: SELECT d4item, isell, SCYSAL, imisc4, daysactive, itmcolor FROM ( SELECT d4item, itmcolor, imisc4, isell, SCYSAL, ROW_NUMBER() OVER (ORDER BY d4item DESC) AS RowNum, DAYS(current date) - DAYS(DATE(TIMESTAMP_FORMAT(CHAR(ITMSTSDATE), 'YYYYMMDD'))) AS daysactive FROM files.drill4 JOIN files.itemsale on D4ITEM = SITEM JOIN files.itemmast ON IITEM = D4ITEM AND ICO = 1 AND ISTATS <> 'V' AND ISELL > 0 AND IITEM NOT IN ('LTM831', 'LTM830') JOIN files.itmmktmst ON D4ITEM = ITMNBR AND itmstatus = 'A' WHERE D4D3A = '1587' OR D4D3B = '1587' OR D4D3C = '1587' ) AS Data WHERE RowNum BETWEEN '1' AND 'PRODUCT_PER_PAGE' ORDER BY d4item DESC System Msg: Conversion error on variable or parameter *N. SQLCODE=-302 System Error No: 22023

DB CONNECTION STOPPED - ERROR CONNECTING - SEE MSG ABOVE