10 Replies Latest reply: Aug 29, 2017 4:29 AM by Viresh Kolagimath RSS

    SQL##f - SqlState: S0022, ErrorCode: 904, ErrorMsg: [Oracle][ODBC][Ora]ORA-00904: "YEAR": invalid identifier

    Viresh Kolagimath

      Hi All,

       

      I am trying to load the below script but getting the error message as

      " SQL##f - SqlState: S0022, ErrorCode: 904, ErrorMsg: [Oracle][ODBC][Ora]ORA-00904: "YEAR": invalid identifier".

       

      script: LET vIncrementalExpression = 'Where a.customer not in (''A'',''B'',''C'') and  YEAR (salhist.dated) >= Year (GETDATE ()) - 3';

       

      Thank You.

       

      Regards,

      Viresh