IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to solve -305 in DB2 ?


IBM Mainframe Forums -> HomeWorks & Requests
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
srk.neeraj

New User


Joined: 09 Feb 2011
Posts: 4
Location: Bangalore

PostPosted: Wed May 18, 2011 1:10 pm
Reply with quote

Could anybody help me iwth -305 in DB2 when I recognize that my Table of 10 records(Rows) the 5th is having this problem , so what should be the beginning and what logic I should make to solve this prob
Back to top
View user's profile Send private message
Stefan

Active User


Joined: 12 Jan 2006
Posts: 110
Location: Germany

PostPosted: Wed May 18, 2011 1:31 pm
Reply with quote

From the manuals:

-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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> HomeWorks & Requests

 


Similar Topics
Topic Forum Replies
No new posts how to solve this power failure shutd... ABENDS & Debugging 5
No new posts Any idea about how to solve 3022 aben... IMS DB/DC 3
No new posts DB2: How to solve -805 DB2 Sql code Mainframe Interview Questions 3
No new posts how to solve -904 in cobol db2 program. DB2 3
No new posts Solve file status code 46 COBOL Programming 19
Search our Forums:

Back to Top