Invalid SQL: SELECT d4item, itmcolor, imisc4, daysactive FROM ( SELECT d4item,itmcolor, imisc4, 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.itemmast on IITEM = D4ITEM AND ICO = 1 AND ISTATS <> 'V' AND ISELL > 0 JOIN files.itmmktmst on D4ITEM = ITMNBR AND itmstatus = 'A' WHERE D4D3A = '837' OR D4D3B = '837' OR D4D3C = '837' ) AS Data WHERE RowNum BETWEEN '1' AND 'PRODUCT_PER_PAGE' System Msg: Conversion error on variable or parameter *N. SQLCODE=-302 System Error No: 22023

DB CONNECTION STOPPED - ERROR CONNECTING - SEE MSG ABOVE