Newbie:Question about binding a program 
Author Message
 Newbie:Question about binding a program

I my shop there is a DB2 subroutine called by about 10 different program to
query different aspects based upon criteria. These 10 programs does not have
any SQL calls, to do SQLs it dynamically calls the db2 sub routine.
 My questions are :

1.  Do I need to bind all these 10 pgms or just the sub routine.
2. If i need to bind all the 10 pgms, is it better to keep them in different
packages and plans or bind all the packages to a single plan ?

2. If its better to keep them only at the package level, how can execute
them.

3. If i make a change to this common subroutine, will I have to re bind all
the 10 programs or just the db2 subroutine ?

Any input is greatly appreciated.

Thanks



Sat, 23 Aug 2003 18:00:00 GMT
 Newbie:Question about binding a program

1. Just the subroutine
2. see above
3. see above

The programs will have to run under a Plan that the subroutines package
exists in.

PF


Quote:

> I my shop there is a DB2 subroutine called by about 10 different program
to
> query different aspects based upon criteria. These 10 programs does not
have
> any SQL calls, to do SQLs it dynamically calls the db2 sub routine.
>  My questions are :

> 1.  Do I need to bind all these 10 pgms or just the sub routine.
> 2. If i need to bind all the 10 pgms, is it better to keep them in
different
> packages and plans or bind all the packages to a single plan ?

> 2. If its better to keep them only at the package level, how can execute
> them.

> 3. If i make a change to this common subroutine, will I have to re bind
all
> the 10 programs or just the db2 subroutine ?

> Any input is greatly appreciated.

> Thanks



Tue, 26 Aug 2003 07:05:53 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Newbie Question: Bound Data Controls with SQL Server 7.0

2. Bound-question from a newbie

3. Newbie Question: Displaying picture in a bound control

4. ADO and Bound Data Combo Control Question - NEWBIE

5. Newbie question about REFCURSOR Bind Variables

6. Newbie question Binding sybase to Multiple IP addresses -- How

7. newbie question: bound solutions and networks

8. Newbie SQL programming question

9. A programming question from a newbie on SQL2K

10. Newbie programming question

11. Newbie Foxpro for windows programming question.

12. Help: NEWBIE dBase III programming question: if/then


 
Powered by phpBB® Forum Software