MVSFORUMS.com

yadav2005 · Intermediate Joined: 10 Jan 2005 Posts: 348 Topics: 144

I was asked in an interview the following DB2 questions.Can somebody help with answers ?

1.What is the difference between PLAN and PACKAGE ?
2.Why do we need both of them / what is the use of both of them ?
3.When do we go for PLAN and when do we go for PACKAGE ?
4.If a main COBOL DB2 program is calling a sub program , will we go for PLAN / PACKAGE ,do we need one plan and one package or do we need one plan only and 2 packages ?
5.Plan is the Executable load module , can Package also be an executable load module ?
6.what is the difference between SQL error code -818 and -805 , are both of them inter-related to each other ?

kolusu · Posted: Fri Feb 16, 2007 12:45 pm Post subject:

yadav2005,

All of the above questions are already answered . Please search the forum. Also check out the DB2 section under TECH FAQ section from the mainpage of mvsforums

www.mvsforums.com

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

Joseph · Beginner Joined: 24 Oct 2007 Posts: 1 Topics: 0

Lot of DB2 interview questions are available in this website
http://db2examples.googlepages.com/faq
All the best,
Joseph