Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try enclosing date in single quotes:
WHERE ACTIVITY_DATE >= '1/1/2015'
Try enclosing date in single quotes:
WHERE ACTIVITY_DATE >= '1/1/2015'
it worked, thanks!