Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Free Package

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Free Package
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: 1754
Location: Bloomington, IL

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

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

A procedure: http://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    Post subject:
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: 1754
Location: Bloomington, IL

PostPosted: Fri Oct 30, 2009 8:44 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Why myself doing Package Bind always ... Susanta DB2 5 Thu Mar 02, 2017 10:47 pm
No new posts JCL to delete component in a package sundaram.naveen Compuware & Other Tools 14 Tue Nov 29, 2016 6:21 pm
No new posts Free FILE not working for specific users sankalp-goyal CLIST & REXX 12 Mon Apr 25, 2016 6:33 pm
No new posts What's plan, package, bind ? jackzhang75 DB2 2 Sun Feb 28, 2016 7:29 pm
No new posts Cobol DB2 package accessing differen... Mainak_Dalal DB2 1 Tue Jan 26, 2016 12:57 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us