Does anyone know why this SQL doesn't work on different ODBC versions using ADO

I'm doing the SQL statement listed below. I'm using D6E, ADO connected to
the IBM AS400 ODBC Driver. We have to deal with two different versions of
the ODBC Driver. Version 7 and Version 10. Version 10 works fine, but
Version 7 doesn't. Currently I'm have to upload 375mg update to get them up
to v10. Any help would be greatly appreciated.

SELECT
"DLDEL#",DLCONO,"DLSEL$","DLVEH$",DLVEHC,DLLHNM,DLVAPR,DLPMTF,DLTERM,"DL$DWN","DL$DOD","DLCDP$",
Date( Digits( DLCDTM ) CONCAT '/' CONCAT digits( DLCDTD ) CONCAT '/' CONCAT
digits( DLCDTY ) ) as ContractDate,
Date( Digits( DLFPMM ) CONCAT '/' CONCAT digits( DLFPMD ) CONCAT '/' CONCAT
digits( DLFPMY ) ) as FirstPayDate,
"DLTIP$","DLLIC$","DLTIT$","DLREG$","DLTOF$","DLSVC$","DLTRD$","DLPOF$","DL$FIN","DLPMY$",DLTFCR,"DLCSP$",DLFEGR,DLBEGR,
CPCKEY,DLCUSMR_CUST_NAME_PREFIX,DLCUSMR_CUST_NAME_FIRST,
DLCUSMR_CUST_NAME_MIDDLE,DLCUSMR_CUST_NAME_LAST,DLCUSMR_HOME_PHONE,
DLCUSMR_CUST_ADDRESS1,DLCUSMR_CUST_ADDRESS2,DLCUSMR_CUST_CITY,
DLCUSMR_CUST_STATE,DLCUSMR_CUST_ZIP,
Date( Digits( DLCUSMR_CUST_DOBM ) CONCAT '/' CONCAT digits(
DLCUSMR_CUST_DOBD ) CONCAT '/' CONCAT digits( DLCUSMR_CUST_DOBY ) ) as
BirthDate,
DLCUSMR_CUST_SOC_SEC_NO,DLCUSMR_WORK_PHONE,DLCUSMR_OTHER_PHONE,
CEMAIL,CECELP,CEFAXP,CEPAGE,
VMSTOK,VMVIN1,VMVMYR,VMMAKD,VMMDLD,VMBODD,VMBMCL,VMDNOU,VMVENG,VMECYL,DLCRTK,VMODOM,
TRMDYR,TRMKDS,TRMDDS,"TRVIN#",TRODOM,DHPSLP,DHSMGR,DHFMGR,DHRFWO
FROM DB20001200.SLDELHPF
LEFT OUTER JOIN DB20001200.SLDEALPF
ON DHCONO = DLCONO AND "DHDEL#" = "DLDEL#" AND DHTOFI = DLSDEL
LEFT OUTER JOIN DB20001200.DLCUSMPF
ON DHBYR1 = DLCUSMR_COMMON_KEY
LEFT OUTER JOIN DB20001200.DLCUSEPF
ON DLCUSMR_COMMON_KEY = CECKEY
LEFT OUTER JOIN DB20001200.VMSOLDPF
ON "DHSTK#" = VMSTOK AND DHCONO = VMCONO AND DLVVIN = VMVIN1
LEFT OUTER JOIN DB20001200.SLTRDEPF
ON DHCONO = TRCONO AND "DLDEL#" = "TRDEL#"
WHERE Date( Digits( DLCDTY ) CONCAT '-' CONCAT digits( DLCDTM ) CONCAT '-'
CONCAT digits( DLCDTD ) ) BETWEEN '6/1/2005' AND '6/10/2005'
ORDER BY DLCONO, "DLDEL#"


Thanks,
Ed


.

Relevant Pages