where clause

[rajtechnocraft]

I am unable put where clause while extracting data from sap R3 system . Its using oracle 9 i.

CUSTOMCONNECT

TO "Provider=QvSAPConnector;ASHOST=192.168.11.243;SYSNR=00;CLIENT=252;XUserId=FSFCQYRNJbaMXUVMXDSB;XPassword=ZBDOBbNMMbcCGYFGWA;";

MATNR:

LOAD

MANDT

,

MATNR

,

ERSDA

,

MTART

,

MBRSH

,

MATKL

,

BISMT

,

MEINS

,

GDS_RELEVANT

,

ZZBPHRASE1

;

SQL

SELECT *

FROM

MARA where MEINS= 'KG'

;

Regards

[prieper]

Seems to be correct. Have you tried to cut this command into steps:
1. SQL SELECT * FROM ...; without any WHERE-clause. if fails, something is wrong with the ODBC
2. add the WHERE. if fails, check whether the field exists
3. your statement and then check if the fieldnames exist in this spelling.

HTH
Peter

[prasad]

Hi,

Change the select statement instead of * , use column names, there should be no problem.

Prasad