3 Replies Latest reply: Jul 27, 2015 10:10 AM by Sasidhar Parupudi RSS

    ODBC READ FAILED

    Deepak Kumar

      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