Re: [SQL] Cursor

2008-08-16 Thread Joe
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 Thanks...guys Assuming you're using ECPG, there are a couple of examples in the documentation, e.g.,

[SQL] Cursor

2008-08-16 Thread Xavier Bermeo
hi guys... This my cursor DECLARE var varchar(15); cursor1 CURSOR FOR select codigo_uni as codigo from recorrido where estado='V'; BEGIN open cursor1; var=cursor1.codigo; END; It's almost 200 records, but, I not unknow how read record for record, I need foun

[SQL] Cursor

2008-08-16 Thread Xavier Bermeo
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 Thanks...guys