| ROWID Null Possible [message #180739] |
Wed, 05 July 2006 01:45 |
mymot
Messages: 225
Registered: July 2005
|
Senior Member |
|
|
Hi,
I am going through Pro C code, and in FETCH statement for particular cursor, i am seeing INIDICATOR for rowid defined in the cursor, then latter code is checking whether that INDICATOR for ROWID is null or not by comparing with -1
long rind;
EXEC SQL mycur cursor FOR
select a
b
t1.rowid
from aa,t1
where <conditions>
....
FETCH mycur into :la
:lb
:lc:rind;
if(rind != -1)
do something
How the rowid can be null for any table?
If the table has no data then , NO_DATA_FOUND will take care and if field is null then using INDICATOR or NVL one could identify field value?
Any expert opnion on this.
Cheers
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
