SQL code -305

SQL code -305

SQL code of -305 is the sql error which results on retrieving a null value in a host variable for which there is no null

When does Sql code -305 comes?

Sqlcode -305 can come if a fetch or embedded SELECT results in assigning a NULL value to a host variable for which a corresponding null indicator is not defined.  

How the system behaves for sqlcode of -305?

The statements can not be executed and no data is retrieved.

How to solve sql code of -305? ; ; ; ;

You can check the name of the host variable which does not have a null indicator defined and then define one for it.