Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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];
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
SAP select don't need comma as field seperator
Ok ...
I don't know about SAP..
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]
why you are using the group by-statement?
check this
your Statement is missing the subselect