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

Anonymous — Fri, 08 Dec 2017 14:41:21 GMT

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

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

sri_c003 — Fri, 08 Dec 2017 17:33:03 GMT

Try enclosing date in single quotes:

WHERE ACTIVITY_DATE >= '1/1/2015'

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

Anonymous — Fri, 08 Dec 2017 18:30:07 GMT

it worked, thanks!

topic "where" function syntax/data load error message - help in Connectivity & Data Prep

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

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

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