DB2 Cursor



IBM's flagship relational database management system

DB2 Cursor

Postby shasbaj » Tue Feb 23, 2010 9:07 pm

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
shasbaj
 
Posts: 3
Joined: Tue Feb 23, 2010 12:07 pm
Has thanked: 0 time
Been thanked: 0 time

Re: DB2 Cursor

Postby GuyC » Tue Feb 23, 2010 10:06 pm

no , program B will not precompile, because the cursor is not declared.
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times

Re: DB2 Cursor

Postby shasbaj » Wed Feb 24, 2010 12:01 pm

Thanks for reply ...in case of static binding it should work because both the program will be having the same load ..please advice .
shasbaj
 
Posts: 3
Joined: Tue Feb 23, 2010 12:07 pm
Has thanked: 0 time
Been thanked: 0 time

Re: DB2 Cursor

Postby shasbaj » Wed Feb 24, 2010 12:04 pm

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 .
shasbaj
 
Posts: 3
Joined: Tue Feb 23, 2010 12:07 pm
Has thanked: 0 time
Been thanked: 0 time

Re: DB2 Cursor

Postby dick scherrer » Thu Feb 25, 2010 1:10 am

Hello,

no , program B will not precompile, because the cursor is not declared.
How you BIND will not solve this. . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post