|
View previous topic :: View next topic
|
| Author |
Message |
Naga Rajender.K
New User
Joined: 19 Dec 2008
Posts: 13
Location: Hyderabad
|
|
|
|
Hi,
I want to delete rows using cursors.I have declared null indicators to two columns which has nulls in 1 row.
I declared as
EXEC SQL BEGIN DECLARE END-EXEC.
01 S-NULL-INDICATORS.
05 S-LNAME-NULL-IND PIC S9(04).
05 S-CITY -NULL-IND PIC S9(04).
EXEC SQL END DECLARE END-EXEC.
I am getting 00000030N while fetching that row.
Pls help me out. |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
| Back to top |
|
|
Srihari Gonugunta
Active User
Joined: 14 Sep 2007
Posts: 295
Location: Singapore
|
|
|
|
Rajendar,
Hope you are using these NULL indicators properly in the FETCH statement. |
|
| Back to top |
|
|
Naga Rajender.K
New User
Joined: 19 Dec 2008
Posts: 13
Location: Hyderabad
|
|
|
|
Hi,
Thanks 4 ur reply. I got it.
regards
Naga |
|
| Back to top |
|
|
|
|
