2 Replies Latest reply: Dec 8, 2017 1:30 PM by scott dealtrey RSS

    "where" function syntax/data load error message - help

    scott dealtrey

      Hi,

       

      Can anyone tell me what the below error message means?

      "

      The following error occurred:

      Connector reply error: SQL##f - SqlState: HY000, ErrorCode: 7200, ErrorMsg: [iAnywhere Solutions][Advantage SQL][ASA] Error 7200: AQE Error: State = S0000; NativeError = 2124; [iAnywhere Solutions][Advantage SQL Engine]Invalid operand for operator: >= -- Location of error in the SQL statement is: 105 (line: 4 column: 48)

      The error occurred here:

      ?

      "

       

      I used this line of code and am only trying to load data from 1/1/2015 onward -

       

      LOAD "ITEM_NBR",

          "TRANS_DATE",

          "ACTIVITY_DATE";

      SQL SELECT "ITEM_NBR",

          "TRANS_DATE",

          "ACTIVITY_DATE"

      FROM "\\server4v\ADaM\AdvData"."IC_AHST" WHERE ACTIVITY_DATE >= 1/1/2015;


      The data loads properly without the "WHERE" function, so I am wondering if i have an issue with syntax or if my data tables are messed up and causing an issue? I am using the correct data format too. Thanks