Regarding cursor in db2.

p_karthikkumar · New User Joined: 19 Mar 2005 Posts: 3 Location: Chennai

Rows in the table are selected if i am using select statement in qmf, But in embedded sql i am using cursor with same select statement, the sqlcode of +100 will occure.Remember i am passing same condition to the host variable. [/b]

p_karthikkumar · New User Joined: 19 Mar 2005 Posts: 3 Location: Chennai

Rows in the table are selected if am using select statement in qmf, but i embedded sql i am using curssor with same select statement, the sqlcode of +100 will occure.Remember i am using same condition in host variable.

mmwife · Super Moderator Joined: 30 May 2003 Posts: 1481

Details?

pa1chandak · Active User Joined: 31 Jan 2006 Posts: 55

+100 is not a error
it is end of table reached

pawan

umeshkmrsh · Active User Joined: 21 Sep 2005 Posts: 81 Location: India

Does your program INSERTS or DELETES record before or after your cursor is OPENNED? If that is the case may be at run time you have no records in the table that you want to fetch using cursor.

If this is nor the case, it's not possible that you will get different results in QMF and runtime using same query.

Regards,
Umesh

nuthan · Posted: Mon Feb 06, 2006 4:24 pm Post subject:

Hi ,
SQL code 100 specifies end of table means searching is over depending on ur condition and it reached the table end but no record satisfies ur condition. I think its not possible to get different results in qmf and prg.Check ur cursor declaration. Better give some more details about ur problem.