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

bhushan munot · New User Joined: 18 Apr 2007 Posts: 7 Location: pune

hi gurus,
i want to know when -3 is returned by null indicator variable

Phrzby Phil · Posted: Sat Apr 21, 2007 1:34 am

Have you done even a rudimentary search?

bhushan munot · New User Joined: 18 Apr 2007 Posts: 7 Location: pune

ashwinreddy · Posted: Tue Apr 24, 2007 11:38 am

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

bhushan munot · New User Joined: 18 Apr 2007 Posts: 7 Location: pune

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.

dick scherrer · Posted: Tue Apr 24, 2007 8:34 pm

Hello,

Why do you think -3 is ever returned?

Phrzby Phil · Posted: Tue Apr 24, 2007 8:58 pm

I can't stand the suspense - here's the answer, fro the IBM website 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.