FM_CUST_CORPORT_CD, FM_IN_NTW_FG, FM_SC_STATE, FMdl_TOTAL_GALLONS, FM_BC_RD_FUEL_RT, FM_SC_RD_CSHADVCRT, FM_CRCY_FG, FM_TR_CASH_ADVCAMT, FM_BILLING_FG, FM_TF_TRACTR_FUEL, FM_TF_TRLR_FUEL, FM_CUST_NAME, FM_BC_RD_SC_SLT_DS, FM_CSTPLS_USED, FM_SLCT_FCS_DISC, FM_CUST_ALLIANC_FG
WHERE FM_RK_TRN_DTE >= '2008-04-28' AND FM_RK_TRN_DTE =< '2008-05-30' AND fm_cust_corport_cd = 'pc222'
FM_RK_TRN_DTE is DATE datatype. The DB2 version is 9, the OS is AIX 5.3.0. I am running this through an ODBC connection, and I get an error that the query was unable to process the data. I've tried different date ranges and I get the same error. I've tried using BETWEEN/AND for the data range, but no luck.