|
View previous topic :: View next topic
|
| Author |
Message |
trevor_rebelo
New User
Joined: 18 Aug 2005
Posts: 17
|
|
|
|
Hi,
I have a Stored Proc bound with 2 collection ID's and i want the same to be bound with another collection ID.
I have not idea where the DBRM is .... and i don't have the source code also..
can we bind a package using the already bound packages....
Regards
Trevor |
|
| Back to top |
|
 |
senthilssg
New User
Joined: 09 Dec 2005
Posts: 64
Location: USA
|
|
|
|
Hi,
You can get the collection id from the stored procedure from the following query. In that you can also have external name. This external name is name of the load module and also name of the DBRM also
| Code: |
| SELECT NAME, COLLID, EXTERNAL_NAME FROM SYSIBM.SYSROUTINES WHERE NAME='stoprocname' AND SCHEMA='schema name'; |
Now you know the DBRM name and collid. So that you can easily able to find the dataset in which DBRM is available by issuing following sql query.
| Code: |
| SELECT NAME, PDSNAME FROM SYSIBM.SYSDBRM WHERE NAME='dbrmname'; |
Please correct me if I?m wrong
Regards
Senthil |
|
| Back to top |
|
|
Hanfur
Active User
Joined: 21 Jun 2006
Posts: 104
|
|
|
|
Trev,
BIND PACKAGE(COLLID) MEMBER(MMNAME) and use REPLACE during BIND since you already know the COLLID of the stored proc it belongs..
-Han. |
|
| Back to top |
|
|
trevor_rebelo
New User
Joined: 18 Aug 2005
Posts: 17
|
|
|
|
| Hanfur wrote: |
Trev,
BIND PACKAGE(COLLID) MEMBER(MMNAME) and use REPLACE during BIND since you already know the COLLID of the stored proc it belongs..
-Han. |
I want the already existing package to New CollID .... but NO DBRM , NO CODE |
|
| Back to top |
|
|
trevor_rebelo
New User
Joined: 18 Aug 2005
Posts: 17
|
|
|
|
Hi Senthil,
the PDSNAME in the SYSPACKAGE is the PDS where the DBRM existed while binding BUT is no longer existing.
in SYSDBRM there is NO entry... |
|
| Back to top |
|
|
trevor_rebelo
New User
Joined: 18 Aug 2005
Posts: 17
|
|
|
|
Hi,
Anyway Thanks for ur suggestions....
I found out 2 solutions ...
1. use the BND024 pgm which comes with BIND MANAGER to create the DBRM from the Package.... (I did not test it as i could not locate the libary)
2. In the DB2I ---- BInd ----BIND package..option we can bind the package either using DBRM (DBRM Option) else using the existing Package (COPY Option)..... (This is workin)
Regards
Trevor |
|
| Back to top |
|
|
|
|
