Warning when selecting from RESB

[Former Member]

Hi Experts,

Below query is giving a warning while doing a syntax check.

SELECT * FROM RESB WHERE RSNUM = CAUFV-RSNUM

AND NO_DISP = SPACE

AND FLGEX NE SPACE

OR DBSKZ = 'F'.

Warning : The field "FLGEX" used in the WHERE condition may contain NULL values.

This warning appears for all selects on RESB table that is an indexed table where selects are done based on AUFPL or APLZL or VORNR or FLGEX.

If only the key fields are used no warning appears and also, the other fields in the above select NO_DISP and DBSKZ give no problem.

They have a customixed secondary index on this table, non unique for columns MANDT and AUFPL.

There is also another INDEX which i think is standard.

Just need your help to find out why this warning appears and is there any solution.

Thanks in advance.

Regards

Raghunahth L

[Former Member]

hi L Raghunahth ,

See in your select statement....i made a chege it may works...

use single codes ( ' ' )then space for check for blank in that field...and in WHERE (RSNUM = CAUFV-RSNUM) before that user Inner join for CAUFV table...it may also cause a problem.

like :

SELECT * FROM RESB INNER JOIN CAUFV ON

RESB_{RSNUM = CAUFV}RSNUM

WHERE RSNUM = CAUFV-RSNUM

AND NO_DISP = ' '

AND FLGEX NE ' '

OR DBSKZ = 'F'.

or go for this Statement

SELECT * FROM RESB WHERE RSNUM = CAUFV-RSNUM

AND NO_DISP = ' '

AND FLGEX NE ' '

OR DBSKZ = 'F'.

Souman

Message was edited by:

Souman Halder