topic Calculation in SAP SQL where clause? in QlikView

Calculation in SAP SQL where clause?

sicilianif — Sat, 01 Aug 2009 02:50:47 GMT

Every time I try to use a calculation in a where clause for an SAP select statement I get an open stream error. Below is the load/select statement that I am issuing. Does anyone know if this works?


 LOAD [/BIC/ZBATCHA],
 CALDAY,
 ISSTOTSTCK,
 MATERIAL,
 RECTOTSTCK;
 SQL SELECT /BIC/ZBATCHA,
 CALDAY,
 ISSTOTSTCK,
 MATERIAL,
 RECTOTSTCK
 FROM /BIC/AZIC_D0500 WHERE RECTOTSTCK - ISSTOTSTCK <> 0;;

Calculation in SAP SQL where clause?

disqr_rm — Sat, 01 Aug 2009 02:58:41 GMT

Try:

LOAD [/BIC/ZBATCHA],
CALDAY,
ISSTOTSTCK,
MATERIAL,
RECTOTSTCK;
SQL SELECT /BIC/ZBATCHA,
CALDAY,
ISSTOTSTCK,
MATERIAL,
RECTOTSTCK
FROM [/BIC/AZIC_D0500] WHERE [RECTOTSTCK] - [ISSTOTSTCK] <> 0;

If doesn't work you may have to move your WHERE condition in preload section. Some thing like this:

LOAD [/BIC/ZBATCHA],
CALDAY,
ISSTOTSTCK,
MATERIAL,
RECTOTSTCK
WHERE RECTOTSTCK - ISSTOTSTCK <> 0;
SQL SELECT /BIC/ZBATCHA,
CALDAY,
ISSTOTSTCK,
MATERIAL,
RECTOTSTCK,
FROM [/BIC/AZIC_D0500];

Calculation in SAP SQL where clause?

sicilianif — Sat, 01 Aug 2009 03:06:14 GMT

Just putting the fields in brackets does not help.

If I put it in the load statement, wouldn't it still pull all the data? I am working with a table that has 65 million records. 20 million+ of which can be weeded out if I can do the calculation.