IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Free Package


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
LearningDb2

New User


Joined: 19 Jun 2009
Posts: 40
Location: India

PostPosted: Fri Oct 30, 2009 7:58 pm
Reply with quote

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
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL

PostPosted: Fri Oct 30, 2009 8:06 pm
Reply with quote

A package: publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.admin.explain.doc/doc/c0021371.html

A procedure: publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.sql.ref.doc/doc/c0004228.html

Read these. When you have absorbed this material to the best of your ability, ask meaningful questions.
Back to top
View user's profile Send private message
LearningDb2

New User


Joined: 19 Jun 2009
Posts: 40
Location: India

PostPosted: Fri Oct 30, 2009 8:32 pm
Reply with quote

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
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL

PostPosted: Fri Oct 30, 2009 8:44 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts LMDINIT/LIST/FREE Looping problem TSO/ISPF 12
No new posts Rebind issue - Package DB2 2
No new posts Am I missing something on "FREE ... CLIST & REXX 10
No new posts CICS exhausted FREE OSCOR CICS 0
No new posts How to free (unalloc) data sets and d... TSO/ISPF 4
Search our Forums:

Back to Top