Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
you can not mix qlikview functions with sql..
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
I think your database is expecting a date time.. try using DT() function