#1: DB2 interview questions Author: yadav2005, Posted: Fri Feb 16, 2007 12:33 pm 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 ?
#2: Author: kolusu, Location: San JosePosted: Fri Feb 16, 2007 12:45 pm 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
#3: Author: Joseph, Posted: Fri Oct 26, 2007 5:49 am Lot of DB2 interview questions are available in this website
http://db2examples.googlepages.com/faq
All the best,
Joseph