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 How to Capture the Max return code of... anilkumar922 All Other Mainframe Topics 0 Thu Jan 12, 2017 12:02 pm
No new posts DFHWS2LS return value divated CICS 4 Mon Nov 07, 2016 5:44 pm
No new posts Syncsort - NULL in Integer field chec... nartcr SYNCSORT 4 Thu Oct 06, 2016 6:47 am
No new posts Format to pipe delimited with variabl... pshongal SYNCSORT 6 Wed Sep 14, 2016 2:48 pm
No new posts Converting NULL column into NOT NULL ... Raghu navaikulam DB2 5 Sat Aug 06, 2016 3:45 pm


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