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
 
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: 965
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: 965
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 DB2 NULL Values display V S Amarendra Reddy DB2 3 Thu Sep 07, 2017 6:59 pm
No new posts Moving values to a variable of copybo... Vignesh Sid COBOL Programming 6 Wed Sep 06, 2017 1:04 pm
No new posts Return a Non Numeric value from REXX Learncoholic CLIST & REXX 3 Fri Sep 01, 2017 8:33 pm
No new posts Updating the Trailer count in variabl... satheshbabur DFSORT/ICETOOL 6 Wed Aug 30, 2017 9:49 pm
No new posts Move from Comp3 variable to Edited Va... sreekusr COBOL Programming 8 Thu Aug 10, 2017 4:20 pm

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