5 Replies Latest reply: Mar 13, 2013 6:33 AM by Adotey Kwame RSS

    Load with a where clause

    Adotey Kwame

      Hi,

       

      The syntax gives an error below

       

      SQL##f - SqlState: S1000, ErrorCode: 4294757240, ErrorMsg: [DataDirect][ODBC OPENEDGE driver][OPENEDGE]Syntax error in SQL statement at or about "DATE(trndat,'dd/MM/yyyy')>= '2010/01/01'" (10713)

      SQL SELECT *

      FROM PUB.uwm100

       

      /////////////////////////////////////////////////////////////////////////////

      load

          a,

          b,

          c,

      DATE(trndat,'dd/MM/yyyy') as %DATE;

       

      SQL SELECT *

      FROM PUB.uwm100

       

      DATE(trndat,'dd/MM/yyyy')>= '2010/01/01';