Page 1 of 1

Program running in loop.

PostPosted: Fri Jul 16, 2010 9:15 am
by XY09
Hi All,

I have wrriten a cobol + Db2 program precompiled & Bind & run. i got desired output.
Next, I have compiled same module without any chnage in the source code, i forgot to bind and when i try to run the job it is going to infinite loop insted of issuing SQLCODE = -805. What was the problem.

Please help..

Re: Program running in loop.

PostPosted: Fri Jul 16, 2010 9:52 am
by dick scherrer
Hello,

That you were able to compile and not bind implies that you are not using standard compile jcl. The standard jcl should include the bind.

If you have created your own compile process, the results may be unpredictable. Developers should use only the standard compile process for the system they are working on.

Suggest you re-compile with the standard and then see if there are any problems.

Re: Program running in loop.

PostPosted: Mon Jul 19, 2010 6:59 pm
by maxcc
isn't it because the timestamp mismatch between the program and dbrm(which was not binded)..

Re: Program running in loop.

PostPosted: Mon Jul 19, 2010 7:03 pm
by maxcc
The plan name used in the JCL and the plan used for bind
should be same...

Re: Program running in loop.

PostPosted: Mon Jul 19, 2010 11:27 pm
by dick scherrer
Hello,

Regardless, there should be no valid compile process that would allow one to "forget to bind". . .