4 Replies Latest reply: Mar 19, 2011 7:07 AM by Luis Laura RSS

    Problem with Odbc for AS 400

       

      the command "where" doesn't work.

       

      This is the code that I use :

      ODBC CONNECT32 TO [AS/400 EDP];

      Test:

      SQL SELECT "COMPANY", "CHIU_CONT", "NUMBER"

      FROM DIREODBC.TABLEDTA09.PPFDST02

      WHERE CHIU_CONT > "01/01/2011";

       

      I have this error :

      SQL##f - SqlState: S0022, ErrorCode: 4294967090, ErrorMsg: [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0206 - Colonna "01/01/2011" non specificata nelle tabelle.

       

      The translationin of the error message :

      SQL##f - SqlState: S0022, ErrorCode: 4294967090, ErrorMsg: [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0206 - Column "01/01/2011" is not specified in the tables.

       

      ( I have also used #01/01/2011# and not this "01/01/2011").

       

      Is there a solution at this problem ?