|
View previous topic :: View next topic
|
| Author |
Message |
sivasaras
New User
Joined: 29 Sep 2007
Posts: 93
Location: chenna/i-
|
|
|
|
Hi,
can we fetch the rows without opening the cursor? kindly let me know
what kind of error we can get?
Thanks in Advance.
Regards,
Siva |
|
| Back to top |
|
 |
balubhat
New User
Joined: 04 Oct 2005
Posts: 19
Location: Singapore
|
|
|
|
Hello Sivasara
I would suggest you to try it yourself.
you will get SQLCODE -501 |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| can we fetch the rows without opening the cursor? |
If the cursor was not opened,what would there be to fetch. . . 
How does such a question originate?
Possibly, this is a completely different question and i've misunderstood. |
|
| Back to top |
|
|
Kjeld
Active User
Joined: 15 Dec 2009
Posts: 365
Location: Denmark
|
|
|
|
If your question is how you can execute a fetch without opening a cursor. Then, you can't, at least not without getting a SQL errror.
But if you are shure your select will return only one row, you can issue the select statement directly in your application program. If the result yields more that one row you will get a -811, as I recall. |
|
| Back to top |
|
|
elijarajesh.mf
Warnings : 1
New User
Joined: 02 Feb 2010
Posts: 14
Location: hyderabad
|
|
|
|
| We can not fetch the rows with out opening the cursor.You will get the SQLCODE as -501. |
|
| Back to top |
|
|
|
|
