A Package basically contains information to process the sql code written in procedure.
But still i cant get the exact usage of the FREE PACKAGE command in db2 ...
Please help me in understanding this..
Joined: 03 Oct 2009 Posts: 1775 Location: Bloomington, IL
Now, the message tells you that you are attempting to free a package belonging to a procedure, not an external program, yes? Moreover, the explanation of the message tells you that it is not possible to free a package belonging to a procedure with the DB2 FREE PACKAGE command, but instead the SQL DROP statement must be used, yes?
Given those circumstances, what do you think should be your next action? Hint: no level of knowledge about FREE PACKAGE will in any way be useful.