Joined: 06 Dec 2004 Posts: 211 Location: Keane Inc., Minneapolis USA.
-305 THE NULL VALUE CANNOT BE ASSIGNED TO OUTPUT HOST VARIABLE. NO INDICATOR VARIABLE IS SPECIFIED
A FETCH, SELECT, VALUES INTO, or SET assignment statement
resulted in the retrieval of a null value to be inserted into the output
host variable. An indicator variable must be supplied if a column returns a null value.
Examine the definition of the table and correct the application program to provide indicator variables for all host variables into which null values can be retrieved. This includes host variables for columns which can contain null values and host variables which receive the results of aggregate functions whose result table could be empty.
Eg: SELECT EMPNO,ENAME,COMM INTO :HV-EMPNO,:HV-ENAME,:HV-COMM:HV-COMMIND FROM EMP WHERE EMPNO=1001;
The host variable :HV-COMMIND is Null indicator. We need to declare it in Working storage section as S9(4).