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]
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.
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.
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.
