|
| Free Plans and Packages |
 |
Sun, 16 Mar 2008 15:45:13 EDT |
Is there a way to find out the list of Plans and Packages which are no longer in
use.<br />
<br />
I can generate the list using the query:<br />
<br />
select <br />
'FREE PACKAGE (' !! strip(COLLID) !! '.' !! strip(NAME) !! '.(' !!<br
/>
version<br />
!! '));' <br />
FROM SYSIBM.SYSPACKAGE <br />
WHERE VALID = 'N' <br />
order by 1 asc<br />
<br />
but it doesnt give a clear picture if thepackages are no more in use. Please
suggest.<br />
<br />
|
| Post Reply
|
|
|
|
|
|
|
|
|
|