View previous topic :: View next topic
|
Author |
Message |
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] |
|
Back to top |
|
|
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. |
|
Back to top |
|
|
mmwife
Super Moderator
Joined: 30 May 2003 Posts: 1592
|
|
|
|
Details? |
|
Back to top |
|
|
pa1chandak Currently Banned New User
Joined: 31 Jan 2006 Posts: 55
|
|
|
|
+100 is not a error
it is end of table reached
pawan |
|
Back to top |
|
|
umeshkmrsh
New User
Joined: 21 Sep 2005 Posts: 79 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 |
|
Back to top |
|
|
nuthan
Active User
Joined: 26 Sep 2005 Posts: 146 Location: Bangalore
|
|
|
|
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. |
|
Back to top |
|
|
|