Page 1 of 1

DB2 Cursor

PostPosted: Tue Feb 23, 2010 9:07 pm
by shasbaj
Hi All,

I have just joined this forum , gone through the posts.It is a great learning.
I have a question that in case there are 2 Programs A and B and program A calls Program B. If I declare cursor and Open it in Program A and try to fetch in program B ?
Will this work or not.

Regards,
Shashank

Re: DB2 Cursor

PostPosted: Tue Feb 23, 2010 10:06 pm
by GuyC
no , program B will not precompile, because the cursor is not declared.

Re: DB2 Cursor

PostPosted: Wed Feb 24, 2010 12:01 pm
by shasbaj
Thanks for reply ...in case of static binding it should work because both the program will be having the same load ..please advice .

Re: DB2 Cursor

PostPosted: Wed Feb 24, 2010 12:04 pm
by shasbaj
Plaese ignore previous mail .
Thanks for reply ...in case of static aly bounded programs it should work because both the program will be having the same load ..please advice .

Re: DB2 Cursor

PostPosted: Thu Feb 25, 2010 1:10 am
by dick scherrer
Hello,

no , program B will not precompile, because the cursor is not declared.
How you BIND will not solve this. . .