Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

What is Null indicator?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
vbhat

New User


Joined: 29 Apr 2005
Posts: 38

PostPosted: Thu May 05, 2005 9:56 am    Post subject: What is Null indicator?
Reply with quote

What is Null indicator?

please explain me

thanks
vbhat
Back to top
View user's profile Send private message

ovreddy

Active User


Joined: 06 Dec 2004
Posts: 211
Location: Keane Inc., Minneapolis USA.

PostPosted: Thu May 05, 2005 4:49 pm    Post subject:
Reply with quote

Hi Bhat,

-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).

:HV-COMMIND = -1 means COMM is NULL.

Thanks,
Reddy.
Back to top
View user's profile Send private message
vbhat

New User


Joined: 29 Apr 2005
Posts: 38

PostPosted: Fri May 06, 2005 10:12 am    Post subject:
Reply with quote

thanks readdy
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Fileaid Update Replace with null string descann Compuware & Other Tools 4 Mon May 15, 2017 3:00 pm
No new posts VALIDATE NULL VALUE IN DB2 CASE STATE... useit DB2 5 Thu Feb 09, 2017 4:34 pm
No new posts Syncsort - NULL in Integer field chec... nartcr SYNCSORT 4 Thu Oct 06, 2016 6:47 am
No new posts Converting NULL column into NOT NULL ... Raghu navaikulam DB2 5 Sat Aug 06, 2016 3:45 pm
No new posts Compare 2 files & write Indicator... nagendrapgupta SYNCSORT 5 Sun May 15, 2016 10:42 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us