Embedded SQL cont'd

["Douglas W. Palme" <dpalme@xxxxxxxxxxx>]

I have a calculated field in my SQL statement that is as follows:

...
((ILNEPRICE - ILNEUAVCST) / ILNEPRICE) as MYPCT
FROM
      LOWMARGNLF
WHERE
      ILNINVDATE <= :DFDATE AND
      ILNINVDATE >= :DSDATE AND
      MYPCT <= :DMARGIN
ORDER BY
      ILNINV#A

C/END-EXEC

DFDATE, DSDATE and DMARGIN as parm that are being passed to the program...

When I run this in interactive mode, everything runs fine....however the sql 
compiler burps by saying that MYPCT is not a field in the table.....is it 
not possible to use this in embedded SQL?  Or do I have to do something 
different?




If you bought it, it was hauled by a truck - somewhere, sometime.