How can I get the read done in parallel when using custom SQL?
Thanks,
Bob
Code: Select all
ODBC_Connector_15,3: [IIS-CONN-ODBC-000016] Execute failed on statement SELECT
CONTQ.ADMIN_CLIENT_ID
,PHN.AREA_CODE
,PHN.EXCHANGE
,PHN.PH_NUMBER
,LOCGRP.SOURCE_IDENT_TP_CD
,CONTGRP.CONT_METH_TP_CD
FROM
M80DV1.CONTEQUIV CONTQ
,M80DV1.LOCATIONGROUP LOCGRP
,M80DV1.CONTACTMETHODGROUP CONTGRP
,M80DV1.PHONENUMBER PHN
WHERE
CONTQ.ADMIN_SYS_TP_CD=190
AND CONTQ.CONT_ID=LOCGRP.CONT_ID
AND LOCGRP.LOC_GROUP_TP_CODE = 'C'
AND LOCGRP.LOCATION_GROUP_ID = CONTGRP.LOCATION_GROUP_ID
AND CONTGRP.CONTACT_METHOD_ID = PHN.CONTACT_METHOD_ID
AND LOCGRP.END_DT IS NULL
fetch first 1000000 rows only
FOR FETCH ONLY WITH UR WHERE (MOD(ADMIN_CLIENT_ID,4) = 3)