4 Replies Latest reply: May 14, 2010 7:04 AM by Mike Welham RSS

    Arithmetic Expressions in SAP Connector SQL SELECT

    Mike Welham

      Hi,

      Does anyone know if you can use an arithmetic expression as part of a SQL SELECT statement using the SAP Connector and if so how do you construct the statement? When I try something like:

      [tempdata]:
      Load
      *
      ;
      SQL SELECT
      MATNR, LFGJA*100 +LFMON
      FROM MBEWH
      WHERE BWKEY = 'XYZ'
      AND LFGJA >= 2000
      ;

      I get an "OpenStream failed. Key = SQL_ERROR ( Number:000) " error message.

      Any suggestions would be most appreciated.