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
 

 

what is difference betwen plan and package??

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
mamta.mf

New User


Joined: 09 Sep 2006
Posts: 1

PostPosted: Sat Sep 09, 2006 11:57 am    Post subject: what is difference betwen plan and package??
Reply with quote

i am having doubts regarding the difference between plan and package in sql..
where exactly the difference occurs and what is the significant aplication of both,,,,
Back to top
View user's profile Send private message

kgumraj

Active User


Joined: 01 May 2006
Posts: 151
Location: Hyderabad

PostPosted: Sat Sep 09, 2006 3:35 pm    Post subject: Re: what is difference betwen plan and package??
Reply with quote

First the concept of plan has come

Plan:-
Plan is a concept where the programs are placed (DBRM's) in other sence, Plan is a collection of DBRM's

Package:-
Each DBRM constitute a Package, and no of packages constitute a plan.

So the modified definetion of the plan is "Collection of DBRM's"

Advantage of Packages over the plan,

I have program A and Program B (subprogram called by program A)
I precomile and place theirs DBRM's in plan. Now a need is their to change the program B. So I need to precompile both Program A and Program B, after chaning the code of Program B

So a concept of Package, Package make only the location like to mainprogram.
If I want to change Program B, I need to Precompile only it. So their is no need to precompile Program A
Back to top
View user's profile Send private message
priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1452
Location: Chicago, IL

PostPosted: Sun Sep 10, 2006 10:41 am    Post subject: Re: what is difference betwen plan and package??
Reply with quote

Check it discussed...
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 -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Difference between TWALENG and TWASIZE Arunkumar Chandrasekaran CICS 3 Tue Jan 03, 2017 12:57 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 Sticky: difference between ... DUMMY ... and ... enrico-sorichetti JCL & VSAM 0 Mon Oct 17, 2016 4:31 pm
No new posts Joinkeys operation betwen VB and FB file Susanta SYNCSORT 4 Sun Sep 25, 2016 9:49 pm
No new posts Difference space showed for TS and it... autobox DB2 1 Thu Apr 14, 2016 1:07 pm


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