#76 Whitespace in SQL > =

closed
nobody
None
5
2010-06-09
2010-05-24
JimN
No

I have found that having a space between > and = is valid SQL syntax, but is rejected by RES.

I can easily fix it by removing the space, but just for completeness thought I would raise the issue (expecting the fix will be quite easy for you).

EXEC SQL
SELECT COUNT(*)
INTO :SV-TOTAL-ROWS
FROM RATINGMETHODUSE A,
WHERE A.PRODUCTID = :SV-Q-PRODUCTID
AND (C.DATEDEACTIVE > =
(SELECT SYSDATE
FROM DUAL)
OR C.DATEDEACTIVE IS NULL)
END-EXEC.

I get the following rejection message.
com.res.cobol.parser.ParseException: Encountered " ">" "> "" at line 548, column 48.
Was expecting:
<EOF>

Thanks.

Discussion

  • VenkatK
    VenkatK
    2010-05-25

    Fixed. Available 05/31/2010.

     
  • VenkatK
    VenkatK
    2010-05-25

    • status: open --> pending
     
  • This Tracker item was closed automatically by the system. It was
    previously set to a Pending status, and the original submitter
    did not respond within 14 days (the time period specified by
    the administrator of this Tracker).

     
    • status: pending --> closed