MVSFORUMS.com

abracadabra · Posted: Fri Oct 08, 2004 10:22 am Post subject: -904 Xped

Hi,

I have an open cursor statement which is getting an SQLCODE of -904. But that is not really my problem. I want to execute the rest of the code by forcing the SQLCODE to zero for this step in XPEDITOR. There are a number of SQL STATE calls after an DB2 statement. I have pur a Break Point before and after the DB2 calls and have done a KEEP on SQLCODE so that when I go to the end of the SQL CALLS, I will force the SQLCODE to 0 instead of -904. However, when I reach the Break point before the DB2 calls and then do a F12 to reach the end of the DB2-SQL calls, the program procssing terminates with -904. It is not going to the 2nd breakpoint at the end of the DB2-SQL calls.
I am probably doing something wrong. Can anyone please help?
_________________
Cheers!

Bithead · Posted: Fri Oct 08, 2004 11:35 am Post subject:

If you are checking SQLSTATE then altering SQLCODE will have no effect. You can bypass the calls by using the S (Skip) command.

abracadabra · Posted: Fri Oct 08, 2004 12:11 pm Post subject:

Not really. I am checking SQLCODE. Let me try SKIP and see. I thought having two breakpoints would solve the problem.
_________________
Cheers!