Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
sdealtrey
Contributor
Contributor

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

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

1 Solution

Accepted Solutions
sri_c003
Partner
Partner

Try enclosing date in single quotes:

WHERE ACTIVITY_DATE >= '1/1/2015'

View solution in original post

2 Replies
sri_c003
Partner
Partner

Try enclosing date in single quotes:

WHERE ACTIVITY_DATE >= '1/1/2015'

View solution in original post

sdealtrey
Contributor
Contributor
Author

it worked, thanks!