You should always turn the NOVALUE condition on. This simplifies the search of an error enormously. You can use the statement SIGNAL to turn the NOVALUE condition on.