Posted by [IP Address: 204.107.47.108] 'Eric Dykstra' on August 20, 2001 at 15:50:34 EST:
I am working with SQR v4.3, on DB2. I am trying to run the following select statement:
Begin-Select
LS.SupL_Wage_Rt,
LS.State,
LS.Suppl_SEP_Method
FROM PS_STATE_TAX_TBL LS
WHERE LS.STATE = <.GRADUATED_TBL_CD
AND LS.EFFDT = (Select Max(LS1.EFFDT)
FROM PS_STATE_TAX_TBL LS1
WHERE LS.STATE = LS1.STATE
AND LS1.EFFDT <= Current_Date)
End-Select
I have narrowed the problem down to this column:
LS.SupL_Wage_Rt
If I remove this cloumn, my select works fine. If I add this column to the select statement, I get the following error:
(SQR 6806) String2Em: String to Decimal Object Conversion Error.
Any one have an answer to this?
Thanks,
Eric