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 

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
badri5
Banned


Joined: 27 Jun 2006
Posts: 17
Topics: 15

PostPosted: Thu Feb 04, 2010 12:05 pm    Post subject: Interview questions Reply with quote

Hi,
Here are some of interview questions.

1)By seeing a DB2 table how will I find out which columns are having constraints
2)In one column of a Db2 table i want to have values like 1,2,3 without using in clause.how will i do that
3)By seeing the jcl how will you find out whether the step is having sort other than external sort.
4)Using redefines clause in cobol which one will give severe error when the redefined clause is more or less.
5)In a db2 table i want to add a column.where do we add in the beginning or in the end.
6)My cobol program is having sort.If we have files we define using assign clause in Program and JCL.For sort in program should i assign for it in the jcl
7)which one is more preferable.Declaring cursor in working storage section or in Procedure division.

Thanks

Badri
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 11827
Topics: 74
Location: San Jose

PostPosted: Fri Feb 05, 2010 11:52 am    Post subject: Reply with quote

badri5,

1. You only will have headache staring at a DB2 table. The answer is NO
2. If the column is defined as character , simply insert a row into the table
3. NO
4. None
5. Depends on the use of column to be added. Usually it is done at the end which involves less work.
6. NO
7. my personal preference is working storage but it doesn't matter where it is defined.

Kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Nic Clouston
Advanced


Joined: 01 Feb 2007
Posts: 997
Topics: 6
Location: At Home

PostPosted: Fri Feb 05, 2010 1:36 pm    Post subject: Reply with quote

3. The JCL MAY have DD statements for SORT libraries and files - but not necessarily if the defaults are OK.
_________________
Utility and Program control cards are NOt, repeat NOT, JCL.
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