stored procedures in db2v7 for z/OS

[login to unmask email]

stored procedures in db2v7 for z/OS
We are just starting to used the stored procedure builder in our
development system.
I have been asked what collection to put them in. Is there an advantage to
having separate collid's for different apps or using the nullid collection.
Thanks

Bud Greenman
Applications Programming Manager

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Myron Miller

Re: stored procedures in db2v7 for z/OS
(in response to BudGreenman@ONGOV.NET)
My suggestion is to not use the NULLID collection for anything other than the
delivered IBM DB2 Connect modules. That way you can tell them from everything
else.

If you put them into collections reflecting your application development
environment, then people will be able to call them with the same qualifier that
other tables are using.

Myron
--- [login to unmask email] wrote:

> We are just starting to used the stored procedure builder in our
> development system.
> I have been asked what collection to put them in. Is there an advantage to
> having separate collid's for different apps or using the nullid collection.
> Thanks
>
> Bud Greenman
> Applications Programming Manager
>
>
---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
> page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
> "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
> The IDUG List Admins can be reached at [login to unmask email] Find
> out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
>

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

[login to unmask email]

Re: stored procedures in db2v7 for z/OS
(in response to Myron Miller)
Thanks. That is what I was thinking too, but I just wanted to confirm it.

Bud Greenman
Applications Programming Manager



Myron Miller
<[login to unmask email]
OO.COM> To
Sent by: DB2 Data [login to unmask email]
Base Discussion cc
List
<[login to unmask email] Subject
ORG> Re: [DB2-L] stored procedures in
db2v7 for z/OS

12/11/2006 04:36
PM


Please respond to
DB2 Database
Discussion list
at IDUG
<[login to unmask email]
2-L.ORG>






My suggestion is to not use the NULLID collection for anything other than
the
delivered IBM DB2 Connect modules. That way you can tell them from
everything
else.

If you put them into collections reflecting your application development
environment, then people will be able to call them with the same qualifier
that
other tables are using.

Myron
--- [login to unmask email] wrote:

> We are just starting to used the stored procedure builder in our
> development system.
> I have been asked what collection to put them in. Is there an advantage
to
> having separate collid's for different apps or using the nullid
collection.
> Thanks
>
> Bud Greenman
> Applications Programming Manager
>
>
---------------------------------------------------------------------------------

> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home
> page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select
> "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org.
> The IDUG List Admins can be reached at [login to unmask email]
Find
> out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm
>

---------------------------------------------------------------------------------

Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org
. The IDUG List Admins can be reached at [login to unmask email]
Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm