View previous topic :: View next topic
|
Author |
Message |
LearningDb2
New User
Joined: 19 Jun 2009 Posts: 40 Location: India
|
|
|
|
Hi,
I am working on db2 9.1 for z/os.
i am trying to free a package using the command---
FREE PACKAGE (collection_id.test_PACKAGE.(V1)) FLAG(I);
When i submit the jcl it gives MAXCC=8
Error code-
DSNT264I DSNTBFR2 FREE ERROR
USING userid AUTHORITY
PACKAGE location_name.collection_id.test_PACKAGE.(V1)
IS A NATIVE SQL PL PROCEDURE PACKAGE
DSNT233I - UNSUCCESSFUL FREE FOR
PACKAGE = location_name.collection_id.userid.test_PACKAGE.(V1)
The explanation of the error code says---
--"To free a native SQL PL PROCUEDURE package, you must use the SQL statement DROP PROCEDURE. "
It means i cant use the FREE command for the same.
If so then what is the difference b/w a package and a procedure..
Please explain me the cause and guide me if i am wrong somewhere.. |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
Back to top |
|
|
LearningDb2
New User
Joined: 19 Jun 2009 Posts: 40 Location: India
|
|
|
|
HI,
thanx Akatsukami
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.. |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 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. |
|
Back to top |
|
|
|