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

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

    scott dealtrey



      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",






      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