View previous topic :: View next topic
|
Author |
Message |
balimanja
New User
Joined: 14 Aug 2007 Posts: 40 Location: Bangalore
|
|
|
|
Hi All,
I recently came across a situation where I am declaring a cursor for a column declared as NULL. Now when I try to fetch this value into a variable I am getting a -305 SQL error code. I saw many examples of how to avoid -305 error when NOT USING A CURSOR, so I tried to use an NULL indicator. Since I am using/declaring a cursor I am not aware as to how to exactly use this NULL indicator. I need your help/suggestions.
Thank you,
Manjunath |
|
Back to top |
|
|
abhishekmdwivedi
New User
Joined: 22 Aug 2006 Posts: 95 Location: india
|
|
Back to top |
|
|
Marso
REXX Moderator
Joined: 13 Mar 2006 Posts: 1353 Location: Israel
|
|
|
|
Use null values in FETCH just as you do in SELECT
FETCH cursor INTO :VAR1:IND1, :VAR2:IND2
Quote: |
Similarly, if :V1:V2 is specified in a FETCH or SELECT INTO statement, and if the value returned is null, V1 is
not changed and V2 is set to -1 or -2. It is set to -1 if the value selected was actually null. It is set to -2 if
the null value was returned because of numeric conversion errors or arithmetic expression errors in the
SELECT list of an outer SELECT statement. It is also set to -2 as the result of a character conversion error.
If the value returned is not null, that value is assigned to V1, and V2 is set to zero (unless the assignment to
V1 requires string truncation, in which case V2 is set to the original length of the string). If an assignment
requires truncation of the seconds part of a time, V2 is set to the number of seconds. |
|
|
Back to top |
|
|
|