DB2 null value, NULL

1. The input parameter is a character type, and is allowed to be empty, you can use COALESCE (InputParameter, ') to convert null to ';

2. Input type is integral type, and allowed to be empty, can use COALESCE (inputparameter,0), turn idling into 0;

3. The input parameter is a character type, and is non-empty, you can use COALESCE (InputParameter, ") to convert null to ', and then determine whether the return value of the function is ';

4. The input type is integer and is non-null and does not require the use of the COALESCE function, directly using is null for a nonempty judgment.

5. Processing of ' value ', ' or ' is not NULL in the database but a space exists need to use = ' ' Authentication

DB2 null value, NULL