IIS-CONN-ODBC-000016

[bobyon]

While trying to coax an ODBC connection to mainframe DB2 ro read in parallel I have encountered the error listed below. It appears as though the SQL statement has been mal-formed with the additional where clause. Is this a bug or am I doing something improper?
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)