sql query not working

[Anonymous]

Dear Experts,

I  am trying to fetch the data from SAP but it gives me Error

/QTQVC/OPEN_STREAM failed after 00:00:00 Key = SQL_ERROR (ID:00 Type:E Number:001 Comma without preceding colon (after OPEN ?).)

SQL Select MANDT OBJNR STAT INACT CHGNR  from JEST WHERE OBJNR IN (select OBJNR from EQUI WHERE EQTYP = 'C') AND [INACT] <> 'X' AND MATCH(STAT,'I0100')

GROUP BY [OBJNR];

below id my table :

[JEST]:   // Individual Object Status

Load

   //MANDT & OBJNR & STAT AS %KEY_JEST_MANDT_OBJNR_STAT,

   [MANDT] as [Client_MANDT],

   [OBJNR] as [Object number_OBJNR],

   [STAT] as [Status_STAT],

   [INACT] as [Status Inact._INACT],

   [CHGNR] as [Change number_CHGNR];

SQL Select MANDT OBJNR STAT INACT CHGNR  from JEST WHERE  OBJNR IN (select OBJNR from EQUI WHERE EQTYP = 'C') and [INACT] <> 'X' AND MATCH([STAT],'I0100') GROUP BY [OBJNR];

STORE * FROM [JEST] INTO E:\demo operation generator\JEST.QVD;

DROP TABLE [JEST];

Can someone let me know how  to solve it.

thanx.

[prma7799]

Comma is missing

Try this

SQL Select MANDT ,OBJNR ,STAT, INACT, CHGNR  from JEST WHERE  OBJNR IN (select OBJNR from EQUI WHERE EQTYP = 'C') and [INACT] <> 'X' AND MATCH([STAT],'I0100') GROUP BY [OBJNR];

[martinpohl]

I'm not sure that sap SQL knows match. use and STAT = '0100'

or

and not INACT = 'X' instead <> 'X'

Bytheway: in big tables like JEST it could be faster to select all datas from SAP and reduce in Qlik when the fields you compare are not with search index

[martinpohl]

SAP select don't need comma as field seperator

[prma7799]

Ok ...

I don't  know about SAP..

[Anonymous]

hi martin

I'm not sure that sap SQL knows match. use and STAT = '0100'

or

and not INACT = 'X' instead <> 'X'

it is not working .it gives error:

QTQVC/OPEN_STREAM failed after 00:00:00 Key = SQL_ERROR (ID:00 Type:E Number:001 Forbidden words used)

SQL SQL Select MANDT OBJNR STAT INACT CHGNR  from JEST WHERE  NOT [INACT] = 'X' AND [STAT] = 'I0100' AND OBJNR IN (select OBJNR from EQUI WHERE EQTYP = 'C')  

GROUP BY [OBJNR]

[martinpohl]

why you are using the group by-statement?

[martinpohl]

check this

http://help.qlik.com/en-US/connectors/Subsystems/SAP_Connectors_Help/Content/6.2/QV-connection/SAP-S...

your Statement is missing the subselect