Example: Following SQL fails at run-time in a DataStage job
Code: Select all
WITH oo AS (SELECT sysdate sysd FROM dual)
, POST_TBL AS (SELECT sysdate POST_DATE FROM dual)
SELECT oo.sysd, 123 EMP_NO, 456 TERR_NO
FROM oo INNER JOIN POST_TBL e
ON oo.sysd>e.post_date;
While parsing table name oo.sysd>e.post_date, the connector detected an unexpected character at position 9. (CC_OraTableNameParser:: parse, file CC_OraTableNameParser.cpp, line 252)
Work around: Add a single space around the join condition symbol. i,e In the SQL given above, if "oo.sysd>e.post_date" is replaced by "oo.sysd > e.post_date", it works fine.
I have raised a PMR for this issue.