|
View previous topic :: View next topic
|
| Author |
Message |
gmosley
New User
Joined: 08 Nov 2006
Posts: 10
Location: North Vancouver
|
|
|
|
| Does anyone know if it's possible to add a Collection ID to the Package List in an existing PLAN using the REBIND command? |
|
| Back to top |
|
 |
GuyC
Senior Member
Joined: 11 Aug 2009
Posts: 1281
Location: Belgium
|
|
|
|
AFAIK you can respecify, but not add.
pklist can be found by following sql :
| Code: |
select location,collid,name
from sysibm.syspacklist
where PLANname = ?
order by SEQNO |
|
|
| Back to top |
|
|
gmosley
New User
Joined: 08 Nov 2006
Posts: 10
Location: North Vancouver
|
|
|
|
| OK, thanks. That's what I suspected (but was hoping to be proven wrong). |
|
| Back to top |
|
|
|
|
