1 Reply Latest reply: Sep 1, 2009 5:14 PM by misterminit RSS

    SAP Connector not able to use "WHERE" in sql statement

    Mikael von Porat

      Hello,

      We have just recently started evaluate SAP Connector and are making some simple tests.

      I've managed to write some simple scripts and downloading data from SAP but as soon as I include a "WHERE" statement I get an error. Can anybody help me?

      Error: OpenStream failed. Key = SQL_ERROR (Number:000) for statement;

      CUSTOMCONNECT TO "Provider=QvSAPConnector;ASHOST=XXXXXXXXXX;SYSNR=;CLIENT=040;UserId=YYYYYYY;Password=XXXXXX;";

      EKKO:

      LOAD MANDT, EBELN, BUKRS, BSTYP, BSART, BSAKZ;

      SQL SELECT MANDT, EBELN, BUKRS, BSTYP, BSART, BSAKZ

      FROM EKKO

      WHERE BUKRS='Z001';

       

      Regards,

      Mikael