Xavier Bermeo wrote:
> Hi, guys.......
> I have problems with cursosrs.
> Anyone have an example complete the how load and read each position
> of a cursor?
> I wait your answer........
Assuming you're using ECPG, there are a couple of examples in the
(see Select using cursors:
The essence is you DECLARE the cursor, OPEN it and then FETCH rows in
some kind of loop, and finish by CLOSE cursor. To exit the loop, you
can check sqlca.sqlcode for 100 (NOT FOUND) or a SQLSTATE of 02000.
In response to
- Cursor at 2008-08-16 17:53:48 from Xavier Bermeo
pgsql-sql by date
|Next:||From: Xavier Bermeo||Date: 2008-08-16 19:35:55|
|Previous:||From: Xavier Bermeo||Date: 2008-08-16 17:53:48|