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
 

 

when a null indicator variable will return a value = -3

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

New User


Joined: 18 Apr 2007
Posts: 7
Location: pune

PostPosted: Fri Apr 20, 2007 7:58 pm    Post subject: when a null indicator variable will return a value = -3
Reply with quote

hi gurus,
i want to know when -3 is returned by null indicator variable
Back to top
View user's profile Send private message

Phrzby Phil

Active Member


Joined: 31 Oct 2006
Posts: 962
Location: Richmond, Virginia

PostPosted: Sat Apr 21, 2007 1:34 am    Post subject:
Reply with quote

Have you done even a rudimentary search?
Back to top
View user's profile Send private message
bhushan munot

New User


Joined: 18 Apr 2007
Posts: 7
Location: pune

PostPosted: Mon Apr 23, 2007 7:09 pm    Post subject:
Reply with quote

Phrzby Phil wrote:
Have you done even a rudimentary search?

no sir i don't know about rudimentry search.
can u pls give me details about what r the diff values that a null indicator variable will return
Back to top
View user's profile Send private message
ashwinreddy

Active User


Joined: 16 Sep 2004
Posts: 106
Location: Hyderabad

PostPosted: Tue Apr 24, 2007 11:38 am    Post subject:
Reply with quote

Hi,

As per my knowledge null indicator has following values

0: Not Null
-1: Null
-2: Truncated (i never used it)

Other than these i never used.

Cheers
Ashwin
Back to top
View user's profile Send private message
bhushan munot

New User


Joined: 18 Apr 2007
Posts: 7
Location: pune

PostPosted: Tue Apr 24, 2007 5:43 pm    Post subject: null indicator variable
Reply with quote

hi ashwin,
thanks for ur reply. but i know all about these values and i want
to know when null indicator variable will return -3.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Apr 24, 2007 8:34 pm    Post subject:
Reply with quote

Hello,

Why do you think -3 is ever returned?
Back to top
View user's profile Send private message
Phrzby Phil

Active Member


Joined: 31 Oct 2006
Posts: 962
Location: Richmond, Virginia

PostPosted: Tue Apr 24, 2007 8:58 pm    Post subject:
Reply with quote

I can't stand the suspense - here's the answer, fro the IBM website http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp

The purposes of the indicator variable are to:

1. Specify the null value. A negative value of the indicator variable specifies the null value. A -1 value indicates that the value that was selected |was the null value. A -2 value indicates that a numeric conversion or arithmetic expression error occurred in the SELECT list of an outer SELECT statement. A -3 value indicates that values were not returned for the row because a hole was detected on a multiple row FETCH. The value of -3 is used only for multiple-row FETCH statements; otherwise, the only indication of a hole is a warning.
2. Record the original length of a truncated string.
3. Indicate that a character could not be converted.
4. Record the seconds portion of a time if the time is truncated on assignment to a host variable.
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 JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts Writing on to GSAM variable length rohanthengal JCL & VSAM 6 Fri Mar 03, 2017 7:46 pm
No new posts VALIDATE NULL VALUE IN DB2 CASE STATE... useit DB2 5 Thu Feb 09, 2017 4:34 pm
No new posts Count Trailing Spaces in variable str... Virendra Shambharkar SYNCSORT 10 Thu Feb 02, 2017 12:23 pm
No new posts MAX-RC 88 and Return code 606 in DFH0... lind sh CICS 2 Tue Jan 24, 2017 1:23 pm


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