Error: F_JD1202: DBMS Error [(80) Syntax or Semantic Analysis Error Thrown in Server While Executing Query

Issue

The following error appears:

F_JD1202: DBMS error [(80) Syntax or semantic analysis error thrown in server while executing query.

Environment

• DSS 6
• Conditions including sysdate

Resolution

To resolve this issue, replace sysdate with current_date in all applicable conditions. For example, instead of WHERE some_column_name>sysdate-2, use WHERE some_column_name>current_date-2.

Cause

This issue occurs when a database-specific construct is used in the wrong database. For example, including sysdate in a condition for a database that does not support sysdate.