Wondering if anyone can help with this issue. I keep getting an oledb read fail from the following. Not a complex query at all and I cannot figure out what could be causing the error. Here is my script:
RA_ADDRESSES_ALL:
LOAD
ADDRESS_ID2 as ADDRESS_ID,
SITE_NUMBER2 as SITE_NUMBER;
SELECT /*+RULE */
HCSU.CUST_ACCT_SITE_ID ADDRESS_ID2,
HZPS.PARTY_SITE_NUMBER SITE_NUMBER2
FROM
HZ_CUST_ACCT_SITES_ALL HCAS,
HZ_CUST_SITE_USES_ALL HCSU,
HZ_PARTY_SITES HZPS
WHERE
HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID
AND HCAS.PARTY_SITE_ID = HZPS.PARTY_SITE_ID
AND HCSU.SITE_USE_CODE = 'BILL_TO';
STORE RA_ADDRESSES_ALL INTO RA_ADDRESSES_ALL.QVD;
DROP TABLE RA_ADDRESSES_ALL;
Any help is greatly appreciated.
