topic where clause in QlikView

where clause

rajtechnocraft — Sat, 10 Oct 2009 14:55:23 GMT

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

where clause

prieper — Sat, 10 Oct 2009 15:02:19 GMT

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

where clause

prasad — Sat, 10 Oct 2009 18:52:34 GMT

Hi,

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

Prasad