This content has been marked as final. Show 3 replies
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