Row Security and NULL values in a column
We have a requirement to apply row security on all tables in JDE on MCU column. We are able to apply it OK; but transactions on few tables fail due to existence of NULL value in this column. The NULL value is being written to few tables as part of third party interfaces.
We tried to make NULL an allowable value in row security. But when we do that, JDE query is run as below -
SELECT * FROM CRPDTA/FXXXXXX WHERE ( HBEDSP = SPACE ) AND ( ( HBMCU BETWEEN ' 1' AND '999999999999' OR HBMCU = ' ALL' OR HBMCU = ' NULL' OR HBMCU = SPACE ) ) ORDER BY HBKCOO ASC,HBDOCO ASC,HBDCTO ASC,HBLNID ASC
We tried to make NULL an allowable value in row security. But when we do that, JDE query is run as below -
SELECT * FROM CRPDTA/FXXXXXX WHERE ( HBEDSP = SPACE ) AND ( ( HBMCU BETWEEN ' 1' AND '999999999999' OR HBMCU = ' ALL' OR HBMCU = ' NULL' OR HBMCU = SPACE ) ) ORDER BY HBKCOO ASC,HBDOCO ASC,HBDCTO ASC,HBLNID ASC
0