Ok, after creating a test procedure and attempting some hard codes we found that the problem was that the UPDATE statement isn’t reading our “FuelPercent” variable correctly and isn’t performing the update. We’re setting the FuelPercent to the Fuel Percent parameter but for some reason the system’s not regarding that as valid. The update works if we replace the FuelPercent variable with pFuelPercent. Why won’t it take the variable? Any ideas?

FuelPercent := pFuelPercent;

UPDATE GMSOWNR.CTB_SA_FUEL CF
SET CF.FUELPERCENT = FuelPercent
WHERE UPPER(RTRIM(LTRIM(CF.PIPELINE))) = UPPER(RTRIM(LTRIM(pPipeline)))
AND UPPER(RTRIM(LTRIM(CF.PRODMONTH))) = UPPER(RTRIM(LTRIM(pProdMonth)))
AND UPPER(RTRIM(LTRIM(CF.PRODYEAR))) = UPPER(RTRIM(LTRIM(pProdYear)))
AND UPPER(RTRIM(LTRIM(CF.POINTOFVIEW))) = UPPER(RTRIM(LTRIM(pFuelType)))
AND UPPER(RTRIM(LTRIM(CF.FUELRANK))) = UPPER(RTRIM(LTRIM(FuelCase)));