Hi...
I am having problems loading the table below. The problem takes place when I add the LOAD part. The query works fine without the load but when the load is added, it gives the ODBC read failed error. I tried changing the field names but nothing is working.
Orders_Tab:
LOAD
date(floor(ORDER_DATE)) AS link_Date,
date(floor(ORDER_DATE)) AS Order_Date, //Load it a second time for making date range selections
ORDER_DATE - yearstart(ORDER_DATE) + 1 AS OrderDayWithinYear,
ORDER_DATE - monthstart(ORDER_DATE) + 1 AS OrderDayWithinYear;
SQL
SELECT trunc(ot.order_date) order_date, qcp.direct_channel channel, decode(qscp.QC_FLASH_SP_TYPE,'Insurance','All Other Home Value Services','Product Warranty','All Other Home Value Services',qscp.QC_FLASH_SP_TYPE) category,ot.oid order_id
FROM orders_tab ot,
qc_cp_master qcp,
qc_report_scp_master qscp
WHERE TRUNC (ot.order_date) BETWEEN TO_DATE ('01/01/2010','MM/DD/YYYY') AND to_date(to_char(sysdate,'MM/DD/YYYY'),'MM/DD/YYYY')
AND ot.entity_oid = qcp.entity_oid
AND ot.order_status > 1
AND qscp.OID = ot.scp_oid ;
