Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ODBC READ FAILED

Hi I m getting this error because of this message QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: 22007, ErrorCode: 4294967116, ErrorMsg: [IBM][CLI Driver][DB2/LINUXX8664] SQL0180N  The syntax of the string representation of a datetime value is incorrect.  SQLSTATE=22007 my load script : load "a",    "b",  "date",    "DESIGNATION"; SQL SELECT * FROM "db.tableemp" where DATE(date)>=DATE('$(vLast27months)'); and where let vLast27months=date(Monthstart(today(),-9*3),'YYYYMMDD'); I m extracting the data using this where condition . Please help me out !!

Message was edited by: Deepak Kumar

3 Replies
sasiparupudi1
Master III
Master III

you can not mix qlikview functions with sql..

Anonymous
Not applicable
Author

Can you send your script again, with break lines? I believe the problem is you using DATE, the Qlikview function, on a SQL script, but I'm not sure because the code is confusing without properly indentation...

-- Lucas

sasiparupudi1
Master III
Master III

I think your database is expecting a date time.. try using DT() function