Check Capture and Check Processing: Appendix

This kind of NULL check (100-CHECK-FOR-NULLS) is highly recommended for numeric fields. Otherwise the program may abnormally end at some place down the line, when the field is used for some arithmetic operation. Instead of NULL indicator, VALUE function can also be used. SELECT VALUE(QUALIFICATION,’ ‘) INTO :WS-QUALIFICATION . FROM EMPTABLE. WHERE EMPID=2052. If QUALIFICATION is NULL… ................
................