MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

DB2 interview questions

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Interview Q & A
View previous topic :: View next topic  
Author Message
yadav2005
Intermediate


Joined: 10 Jan 2005
Posts: 348
Topics: 144

PostPosted: Fri Feb 16, 2007 12:33 pm    Post subject: DB2 interview questions Reply with quote

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 ?
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12357
Topics: 75
Location: San Jose

PostPosted: Fri Feb 16, 2007 12:45 pm    Post subject: Reply with quote

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 - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Joseph
Beginner


Joined: 24 Oct 2007
Posts: 1
Topics: 0

PostPosted: Fri Oct 26, 2007 5:49 am    Post subject: Reply with quote

Lot of DB2 interview questions are available in this website
http://db2examples.googlepages.com/faq
All the best,
Joseph
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Interview Q & A All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group