Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
How to solve -305 in DB2 ?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> HomeWorks & Requests
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    Post subject: How to solve -305 in DB2 ?
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> HomeWorks & Requests All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DB2: How to solve -805 DB2 Sql code trushant.w Mainframe Interview Questions 3 Fri Oct 04, 2013 3:47 pm
No new posts how to solve -904 in cobol db2 program. Escapa DB2 3 Tue Jul 19, 2011 5:34 pm
No new posts Solve file status code 46 Robert Sample COBOL Programming 20 Tue May 04, 2010 4:07 pm
No new posts CSKL:EZY1295E BIND CALL FAILURE.Pleas... tiger_wen CICS 19 Thu Feb 04, 2010 10:39 pm
No new posts How to solve tape GDG contention nemo_budd JCL & VSAM 3 Fri Nov 06, 2009 8:59 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us