Interview Questions   Tutorials   Discussions   Programs   

DB2 - How to resolve the -305 error code in DB2? And also how to resolve the db2 error codes?

    Next Topic



468
views
asked mar August 3, 2014 05:23 AM  

How to resolve the -305 error code in DB2? And also how to resolve the db2 error codes?


           

1 Answers



 
answered By Mswami   0  
SQL Code: -305
THE NULL VALUE CANNOT BE ASSIGNED TO OUTPUT HOST VARIABLE NUMBER position-number BECAUSE NO INDICATOR VARIABLE IS SPECIFIED.

Explanation:
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, designated by entry number 'position-number' of the output SQLDA, for which no indicator variable was provided. An indicator variable must be supplied if a column returns a null value.

System action:
The statement cannot be processed. No data was retrieved.

Programmer response:
Examine the definition of the table that is the object of the statement 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.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert